Query and subform

[Guest]

Hi all,
help with this would be great and appreciated.

I have a simple database with 1 main table, i have created a query that
looks up the records of a field and work well. I'd like to be able to create
a form/subform that allows the user to click a button to type in the job
number click ok then have all related records show up in the sub form below.

I have the form witht he sub form showing, created the button that runs the
query but the query shows the resulting table in a new window, is there any
way to get this to show up in a subform of the existing form?

thanks
leo

 

[Guest]

1. Create a form that it's record source is the query you created.
2. In the main form, add a sub form control and link it to the form you
created in stage 1
3. On the AfterUpdate event of the combo you'll need to run the code that
refresh the data in the sub form

Me.[SubForm Control Name].Requery