Help with a Form

[ramrags]

I'm try to make a form for a small doctors office. I would like the form to lookup vaules from a patient registration table and add these vaules to a hospital reservation form. I made a prameter query, and made a form from it and it works fine untill a patient need to make another reservation, the fields from the first form are filled and the form is complete. Which is how the query should work. How can I make it so
that when I open the form and give it the prameter only the patient information is filled in. Thanks to anyone who can help!

 

[rhinoman]

Sounds like you need to change the form to be a master/detail format.

That is each patient detail is at the top and reservation history for that patient is in a grid or separate form below this.

You will need to modify the query to only bring back patient details and create a new query to bring back reservation info based on the patient Id. You can then put them together on the one form.

Check Help for Master./Detail to get you started.