Limit Combobox based on Open Form

[kidego32]

Hi all,

I have a combobox that displays items from a lookup table.

I need to limit the list of items in the combobox based on the form that the user opens.

For example:

User opens form for entering Mirror Codes. The combobox in the form should only display the corresponding items from the lookup table.

User opens form for entering Glass Codes. The combobox should only display the corresponding items from the same lookup table.

Thanks,

Julio

 

[jtvcs]

Did you try using a query to fill the Combo Box instead of the Lookup Table itself ? HTH JT

 

[Robert Dunstan]

Hi

Assuming your lookup table has a field that identifies each record as a glass code or mirror code etc. e.g. may be a category field, you'll need to set the criteria in the underlying the row source of your combo box