Originally Posted by
ItsMe
...You need to take your form out of modal if you are going to reference a control on another form...
Sorry, but that's not correct..
Originally Posted by
crowegreg
...Since frm_PC_log is the form that opened the modal form, it is still open...
Since frm_PC_log is Open, you can assign a Value from the Modal Search Form by placing this code in an appropriate event in the Modal Form:
Forms("frm_PC_log")!F1ControlName = Me.F2ControlName
or
Forms!frm_PC_log!F1ControlName = Me.F2ControlName
where
F1ControlName is the Control on frm_PC_log that you want the data assigned to
and
F2ControlName is the Control on the Modal Form that holds the data to be assigned back to frm_PC_log
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007