Auto-fill a subform

[ssmith001]

I have a main form where a user can choose a location number from a dropdown box. Once they have selected a location, I populate some other text boxes for address, city, state, etc. based on the selected location. This part is working correctly. They can then press a command button to query the database based on this location number. Here's where I need help. When they press this button, I need to query the DB and place the returned records into a subform. How can I do this?

 

[unclejoe]

Hi,

Try
Here

I have a main form where a user can choose a location number from a dropdown box. Once they have selected a location, I populate some other text boxes for address, city, state, etc. based on the selected location. This part is working correctly. They can then press a command button to query the database based on this location number. Here's where I need help. When they press this button, I need to query the DB and place the returned records into a subform. How can I do this?