Hi All,
I am new to Access - so please bear with me.
I have 2 tables.
Table 1 has a unique site identifier field for each record. From a form I would like the user to enter the site identifier, which would result in the site address data for that record being retrieved from Table 1. This address cannot be changed on this form, so I assume I will need to display it in a message box on the form?
The user (on the same form) then proceeds to enter other data to update Table 2.
I know how to use a form to input data, but don't know how to get it to recall and display data based upon the site identifier.
Any assistance would be much appreciated.
All the Best,
Ian [/b]
I am new to Access - so please bear with me.
I have 2 tables.
Table 1 has a unique site identifier field for each record. From a form I would like the user to enter the site identifier, which would result in the site address data for that record being retrieved from Table 1. This address cannot be changed on this form, so I assume I will need to display it in a message box on the form?
The user (on the same form) then proceeds to enter other data to update Table 2.
I know how to use a form to input data, but don't know how to get it to recall and display data based upon the site identifier.
Any assistance would be much appreciated.
All the Best,
Ian [/b]