On a form that is opened from my main form, is there a way to set the default value for a field to equal that of the main form?
I typically use the following:
[Forms]![JobQuote]![JobID]
JobID is what keeps everything under a certain job within my application. What I am trying to do, is when the second form is opened (via a button on the main form that opens the form to records with the matching JobID), is set the default value of the JobID field to equal to the value of the JobID from the main form. This is so if the user enters additional data, it will automatically assign it the relevant JobID. The data within the form is populated via data imported from excel that is assigned all of its relevant ID's during the import process, so any data added in by the user after the fact needs the JobID added to it.
Using the syntax above does not do anything and just throws a #NAME error within the field.
How can I set the default value for my JobID to equal the JobID from the main form?
I typically use the following:
[Forms]![JobQuote]![JobID]
JobID is what keeps everything under a certain job within my application. What I am trying to do, is when the second form is opened (via a button on the main form that opens the form to records with the matching JobID), is set the default value of the JobID field to equal to the value of the JobID from the main form. This is so if the user enters additional data, it will automatically assign it the relevant JobID. The data within the form is populated via data imported from excel that is assigned all of its relevant ID's during the import process, so any data added in by the user after the fact needs the JobID added to it.
Using the syntax above does not do anything and just throws a #NAME error within the field.
How can I set the default value for my JobID to equal the JobID from the main form?