I have two tables, a query that joins the two tables and two forms.
The Table 1 has an auto-number field called "Record." Table 2 has a number field called "Record" (these two fields are my join).
On Form 1 I have the auto-number field "Record" and on Form 2 I have the number field "Record." I use a command button to call Form 2 from Form 1. I would like to type my information in Form 1 (the auto-number field would automatically update) and when I click the command button to call Form 2, I would like the matching field "Record" to automatically be updated with same number as the auto-number field from Form 1.
Can this be done?
The Table 1 has an auto-number field called "Record." Table 2 has a number field called "Record" (these two fields are my join).
On Form 1 I have the auto-number field "Record" and on Form 2 I have the number field "Record." I use a command button to call Form 2 from Form 1. I would like to type my information in Form 1 (the auto-number field would automatically update) and when I click the command button to call Form 2, I would like the matching field "Record" to automatically be updated with same number as the auto-number field from Form 1.
Can this be done?