Hi I have a query that runs and opens a form. The query returns many records
so I have to scroll through till I find the record I'm looking for. I then
have a button that takes the data from the form and runs and uses it to run
an append query. The query data and more is saved to the database and opens a
form with all of the info on it. the form also has some questions that can be
answered. The problem is I can seem to find a way to get the second form to
open up on the record from the first form, right now it opens fine but not on
the record you just selected from the first form. Any ides, I have had no
luck with gotorecord

This is what I have in my macro sorry should have posted earlier

stDocName = "Add ZZZZ Completion Querie"
DoCmd.OpenQuery stDocName, acNormal, acEdit runs append query using data in
first form

stDocName = "Add ZZZZ Completion Form"
DoCmd.OpenForm stDocName

The last part opens form with queried data but not on correct data that was
in the first form

Not sure if this will help, but take a look at the syntax of the OpenForm
command. There should be a parameter for Open Arguments, which would allow
you to "pass" a value to the form.

There should also be a parameter for a Filter, and for a WHERE clause, to
help a particular record or set of records be loaded with the form.

--
Good luck

Jeff Boyce
<Access MVP>

"Skiiny_jd" <(E-Mail Removed)> wrote in message
news:CC42981D-5BFB-4CCF-940D-(E-Mail Removed)...
> Hi I have a query that runs and opens a form. The query returns many
records
> so I have to scroll through till I find the record I'm looking for. I then
> have a button that takes the data from the form and runs and uses it to
run
> an append query. The query data and more is saved to the database and
opens a
> form with all of the info on it. the form also has some questions that can
be
> answered. The problem is I can seem to find a way to get the second form
to
> open up on the record from the first form, right now it opens fine but not
on
> the record you just selected from the first form. Any ides, I have had no
> luck with gotorecord
>
> This is what I have in my macro sorry should have posted earlier
>
> stDocName = "Add ZZZZ Completion Querie"
> DoCmd.OpenQuery stDocName, acNormal, acEdit runs append query using data
in
> first form
>
> stDocName = "Add ZZZZ Completion Form"
> DoCmd.OpenForm stDocName
>
> The last part opens form with queried data but not on correct data that
was
> in the first form