Queries on forms....

[quasimodo]

I'm doing a hotel booking system on Microsoft Access.

I have a form for recording any messages onto a message table. On the form, I have a search button on the form, for the receptionist to search for any messages for a particular room. Its a parameter query, and when the button is clicked, it runs the query, which asks for the room number the messages are wanted for, and brings up the results. The search results come up on a new window, and i was wondering whether it was possible to have the results show up on the same form??

 

[Mile-O]

Put a subform onto your form and use that to display the results.

 

[quasimodo]

thanks for your help...

i'm new to access, so i mite be needing a lot more of your help.

 

[quasimodo]

i've cant the search results to appear in the subform. They still open in a new window.

I produced another form for the search results to be brought up in. I tried putting this as a subform, but, then, whenever the messages form was opened, the query ran staight away, and asked for room number. I only want to query to run when the search button is, but want the results to appear in the sub-form, in a form format, not a table format.

Can any1 help me with this....?