D
dar
I’m pretty sure my problem is syntax.
MainForm is frmRHCF1
SubForm is RHCF1
Control on SubForm is Unit
MainForm and SubForm linked by PatientID
SubForm has Unit control:
Table = UnitAssignment
(holds therapists initials based on Unit) ex. FA2E = KW under OT
The code below works if I open SubForm stand alone.
If I open Main form, I receive Error message.
=DLookUp("Ottherapist","UnitAssignment","Unit=Forms!RHCF1.Unit")
I have searched for answers but seem to thick to grasp the correct syntax.
I went to website which had several examples, none of which I seem to make
work. So, please help here if you can.
Thanks
MainForm is frmRHCF1
SubForm is RHCF1
Control on SubForm is Unit
MainForm and SubForm linked by PatientID
SubForm has Unit control:
Table = UnitAssignment
(holds therapists initials based on Unit) ex. FA2E = KW under OT
The code below works if I open SubForm stand alone.
If I open Main form, I receive Error message.
=DLookUp("Ottherapist","UnitAssignment","Unit=Forms!RHCF1.Unit")
I have searched for answers but seem to thick to grasp the correct syntax.
I went to website which had several examples, none of which I seem to make
work. So, please help here if you can.
Thanks