forms applying data to the correct record

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

Guest

I have multiple forms that Dump to multipe tables all with auto number keys.
I have set up multiple command buttons that that send you to diffrent forms
base on responces in the form. however when the command button is hit the
next form that opens up is not the same record . You actually over-write
record one and not move in succession with the same record how do I fix.
 
You will need to examine the DoCmd.OpenForm statement in the code associated
with the Click event of the command buttons, and set the WhereCondition
argument to the unique identifier of the record you want. That will require
some minimal knowledge of VBA coding. If you do not have any VBA coding
skills, if you will post back here, perhaps someone can ask you the
pertinent questions and assist you in creating it.

Larry Linson
Microsoft Access MVP
 
Back
Top