Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Popup table won't link to current record on master form.

Status
Not open for further replies.

hefly

Technical User
Feb 6, 2008
134
US
I have a form which I want to create a popup form linked to the current record.

I have tried to create a macro to open my popup form, but I get a message box prompting me for a parameter. If I enter the LeaseID which is being prompted for, the popup opens to the correct record. I would like to skip having to enter the LeaseID and have the form open to the current record displayed on the open form.

Form and popup form need to be linked via field "LeaseID"

My macro is described as follows:

Action: Open Form
Argument: sfmlTracts, Form,, [LeaseID]=me.LeaseID,,Normal

Form: frmLeases
View: Form
Where condition: [LeaseID]=me.LeaseID
Data Mode: blank
Windows Mode: Normal


Many thanks.
Hefly
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top