Two Forms One Record

[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..

 

[Arvin Meyer [MVP]]

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