Help with a query

[Guest]

Help.

I have a query that runs and opens a form. The form has many records
associated with it and when the query runs it does not open to the data you
just queried on. Does anyone know how the code to get the form assocated
with the query to open on the data you just queried on???

 

[Rick B]

I don't understand the question. The query pulls up the records you want to
see if you run the query by itself? The form does not display the same
thing as the query?

Rick B

 

[Guest]

The query pulls up info in a form. In this form there are many records.
Once you find the record you want, you hit a button in the form that runs an
append query that adds the information in the first form along with some
additional info into the main database. It then opens the main database form
with all of the records in the database, but not on the record you just
queried on.