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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select popup record - Set value subform combo?

Status
Not open for further replies.

misscrf

Technical User
Jun 7, 2004
1,344
US
I have a button on a subform to view and enter contacts. On any given record you can just close the form, or you can choose that current record and have it pick that record from a combo on a subform. Only problem is that I have no idea how to do that, lol. I have been searching and looking at stuff but I can't seem to find out how to take the current record from the subform, and set it's PK value to the combo on a subform in another form that is open.

Can anyone help me with this, please?

I tried putting this on the pop up form command button:
Code:
Forms![frmmain]![frmsubform].Form![FKComboOnSubForm].Value = Me.PKValueIDOnPopUpForm

When I try to click the button I get a message that says:
The expression you entered refers to an object that is closed or doesn't exist.

Any thoughts?

misscrf

It is never too late to become what you could have been ~ George Eliot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top