Use the primary key of the record in the form to open the other form to the
same record.
This example shows the Event Procedure you could use for a command button
named OpenThisRecord, assuming a primary key named ID:
Private cmdOpenThisRecord_Click()
Dim strWhere As String
If Me.Dirty Then
Me.Dirty = False 'Save
End If
If Me.NewRecord Then
MsgBox "Select a record."
Else
strWhere = "[ID] = " & Me.ID
DoCmd.OpenForm "Form2", WhereCondition:=strWhere
End If
End Sub
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<La*****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I have been looking for a way to figure out how to pass specific record
information from a continuous form onto another form. What I have done
was created a button in the detail section to open another form. This
form has text boxes and I linked their properties to the first form,
but it pulls the first record's information instead of the one the
button is next to. How can I accomplish this?
I have been looking for information for a few days now and have given
in to start a new topic. Your help is very much appreciated.