Form Navigation

[Neil]

Lets hope you guys can understand what I want.

I have this form (form1) which creates records in a table
(Table1). Depending on your selection in Form1 it opens
another form (form2). This new form will create records
in other tables. The tables are related such that
records created in Form2 are associated with one
particular record that was created in Form1.

My question is that when a new record is made in Form1
and the next button is hit to go to Form2, the details
for the first record in Form2 is shown not the
corresponding details for the newly created record. The
navigation buttons need to be utilised to move to the new
record and the details entered.

How do I make it so that going from Form1 to Form2 will
present me with the details on Form2 for the record I
entered in Form1?

Ideally I would like to eliminate the navigation keys.

 

[Wayne Morgan]

It sounds as if you are saving the record before opening Form2 or you
wouldn't be able to find the record using the record selectors. The easiest
way is probably to use the WhereCondition in the DoCmd.OpenForm call.

"[UniqueIDField]=" & Me.txtUniqueID
or if the ID is a text value
"[UniqueIDField]='" & Me.txtUniqueID &"'"