Get The Values In The DropDown

vivek_inos · November 30th, 2005, 08:34 AM

I have UserID(ie who has logged in) on the Main Form.

As I Open Form I want to Populate DropDown With ContactID Where UserID is Equal To UserID on the Main Form.

UserID and ContactID are in the Same table.

I do not want to see All the ContactID but Only Those ContactID Where UserID is Equal to UserID on the Main Form.

OR

How I can Fill Data in The Comobox through code.
I Tried Combox.Value= and Combox.Text=
But it Does'nt Work

Can SomeOne Help Me.

Best Regards,
Vivek.

mmcdonal · November 30th, 2005, 09:13 AM

Go to the combo box properties dialog, then click the data tab and then open the query that populates the combo box.

Add this field to the query: UserID

If you don't modify the code that formats the combo box fields, then this added field will not show up when the box is searched.

Then add this criteria to the UserID field you just added to the query: Forms!frmMainFormName.UserID

This will prevent the combo box from showing records that do not belong to the UserID.

HTH

mmcdonal

vivek_inos · November 30th, 2005, 09:45 AM

Quote:

quote:Originally posted by mmcdonal
Go to the combo box properties dialog, then click the data tab and then open the query that populates the combo box.

Add this field to the query: UserID

If you don't modify the code that formats the combo box fields, then this added field will not show up when the box is searched.

Then add this criteria to the UserID field you just added to the query: Forms!frmMainFormName.UserID

This will prevent the combo box from showing records that do not belong to the UserID.

HTH

mmcdonal

I haven't Written Any Query in Properties of the Combo Box.
But I have got the ContactID of that USer through Code.
my Email ID is [email protected]
please do post any suggestion

Best Regards,
Vivek.