pop-up form synchronizing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with 5 fields. "feild1,feild2...,field5.

I have a form based on field1, field2, and field3.
I want to open a pop-up based on field4, and field5. When I do, it opens to
record one. I want it to open to the same record that the first form is on.
For instance, if I am on record 129 of 438, I want to open my pop-up on
record 129 or 438.

How do I do this???

Thanks
 
You can use the "wherecondition" argument of the OpenForm Method to open the
pop-up Forms at the same Record with the main Form.

Check Access VB Help on the OpenForm Method.
 
Thanks, but what do I put in the WHERE clause? the help screen only told me
the syntax of the method.
 
See the "Using the wherecondition Argument" section in this article if
you have local MSDN content installed with Visual Studio:

ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/bapp2000/html/acbachap03.htm
 
DoCmd.OpenForm "frmPopUp",,, "[RecordID] = " & Me.RecordID

(replacing "RecordID" with the Field name from your Form's RecordSource that
*uniquely* identifies the required Record)
 
Back
Top