Lookup fields 1

[jfrasier]

What I would like to do on a form is for the user to pick a value from a dropdown list and then another lookup field on that form would only have values pertaining to the first choice. In other words a field for state -- the user picks New York and then for city, they only get the choices for cities in New York.

How do you do that?

J. Frasier

 

[JerryDennison]

Cascading Combobox is what this is referred to. You set the criteria of the second combobox on the choice of the first. The rowsource of the second combobox should include the bound column of the first combobox then set this fields criteria as follows:

Forms!FormName!Combobox1

In the AfterUpdate Event property of combobox1 you requery combobox2

Me.Combobox1.Requery

 

[jfrasier]

Thanks. I'll try that.

Jane