How do I...??

  • Thread starter Thread starter Ken
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data from a subform into a query 2
synchronized Combo Boxes in subforms 2
Cascading combos in datasheet 0
*HELP* with sorting in Basicform & Subform.. Access 2010 0
Subform Value Does Not Display in Form (but will in table) 1
How do I get the sub form to display a blank record? 5
2007 Multi Value Check Box Lists 1
First Subform record gets modified when closing form 3

Back
Top