Pop up form same record

[jeremy0028]

I have a table and form called patient info

All the following fields are in one record

Main form called patient info

Account#(pk)Auto Number
Last Name
First Name
Address
City
State
Zip
Phone

I also i have a command button on main form called primary subscriber info which opens a pop up form called primary subscriber info which has the following

Insured First Name
Insured Last Name
Insured Address
Insured City
Insured State, Insured Zip

How do i tell access when i press the command button to relate form to patient account on main form called patient info

When ever i press command button relates to first record which i dont want

Any Ideas

 

[THWatson]

jeremy
You need to add a WHERE clause to the DoCmd statement. Something like the following...

Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "YourFormName"
    stLinkCriteria = "[RecordID]=" & Me![RecordID]

DoCmd.OpenForm stDocName, , , stLinkCriteria

Tom

 

[jeremy0028]

That worked thank you very much