Hello,
Could somebody please tell me how to write my Where statement without specifically mentioning the exact name of the parent form?
This is what I have right now:
WHERE (((tblOptions.OptionsID)=Forms!frmBrowseApplications!sfrmOptions!OptionsID));
It works, but I'd like to get rid of "frmBrowseApplications". And "sfrmOptions" as well if possible. I've been experimenting with "parent" and "me", but either that can't be done or I just haven't hit the jackpot yet.
Thank you.
Could somebody please tell me how to write my Where statement without specifically mentioning the exact name of the parent form?
This is what I have right now:
WHERE (((tblOptions.OptionsID)=Forms!frmBrowseApplications!sfrmOptions!OptionsID));
It works, but I'd like to get rid of "frmBrowseApplications". And "sfrmOptions" as well if possible. I've been experimenting with "parent" and "me", but either that can't be done or I just haven't hit the jackpot yet.
Thank you.