Access Macro Help Please!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top