Two Forms One Record

  • Thread starter Thread starter shie
  • Start date Start date
S

shie

Hi! Im a beginner in access. I have two forms (BirthCertificate and
BirthCertificate2) that share one recordset(?) --> one row in a table . I
separated them due to many fields. I have a command button that opens the
other form but I want it to open on same page as the first page on my first
form -- like continuing to type on a table..
 
The code should read something like (untested):

DoCmd.OpenForm "Your second form" ,,, "PrimaryKey = " & Me.txtPK

where "Your second form" is the name of the second form
PrimaryKey is the name of that key in your table
txtPK is the name of the text box on your first form where the PrimaryKey is
located
 
Back
Top