How do I...??

K

Ken

Greetings all:

I want to create a lookup form/subform combo. The main form will have
a combo box with a list of states, I want to display the results of a
query that will be driven by the state abbreviation. I can set up the
combo box, I'm having a hard time figuring out how to get the subform
(merely a datasheet) to display with the results.

I'm sure it's obvious, but obvious just isn't happening to me right
now.

TIA for any and all help.

Ken Halpern
 
A

Arvin Meyer [MVP]

Use a query as the recordsource of the subform. As the query's criteria,
click the Build button or just type in:

[Forms]![YourFormName]![The Combobox Name]

Then in the Click event of the combo box on the form add an [Event
Procedure] with this piece of code:

Me.[ComboBox Name].Requery
 
Top