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:
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
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