pop-up form synchronizing

[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

 

[Van T. Dinh]

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.

 

[Guest]

Thanks, but what do I put in the WHERE clause? the help screen only told me
the syntax of the method.

 

[ksquare]

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

 

[Van T. Dinh]

DoCmd.OpenForm "frmPopUp",,, "[RecordID] = " & Me.RecordID

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