Property Get / DLookup Function Problem

access7

Registered User.
Local time
Today, 16:16
Joined
Mar 15, 2011
Messages
172
Hello,

I am hoping someone with a bit more experience / knowledge than myself could tell me whether I am 'barking up the right or wrong tree' with this one...

I am trying to get two fields ("CompanyRef" and "ContactRef") on Frm_Action to autopopulate on load of the form with the values from the fields "CompanyRef" and "ContactRef" on the current record that is open on Frm_Company.

I have used a Property Get statement and the DLookup Function in another part of my code (for Frm_Company) but I cant seem to get it to work the same for the Frm_Action... I have tried different variations

Sorry, I am still quite new to all of this...

Is there any easier way to achieve this? :confused:

Thanks in anticipation....
 

Attachments

I think I may have solved this by using the 'OpenArgs' :)
Its working for one field anyway; just got to get it working for the other now; may be slightly more complicated in that I want to send a value from a field on a sub form of a form to the new form.
I'm going to give it my best shot :-)
Thanks
 

Users who are viewing this thread

Back
Top Bottom