G
Guest
Hi,
I regularly have to fill in forms with inspection data.
On the form, there is a drop down box with the list of inspection locations,
there are then several more boxes that need data inputted, e.g. id numbers,
inspector's name, equipment type etc, that are always the same for each
location.
I have a table with the inspections locations, then the corresponding id
numbers etc in rows. At the moment I am ctrl C ctrl V each bit of data from
the table into the form (each completed form is then exported and recorded
for analysing, the process repeats).
I then input the inspection data into the form, copied from regular emails.
Ideally I would be able to choose the location from the drop down list, then
the various fields with data in automatically fill in. I'm not familiar at
all with Access (new job and all that), but have a fair amount of computer
literacy.
I'm using Access 2003.
Thanks for any help,
Profqwerty
I regularly have to fill in forms with inspection data.
On the form, there is a drop down box with the list of inspection locations,
there are then several more boxes that need data inputted, e.g. id numbers,
inspector's name, equipment type etc, that are always the same for each
location.
I have a table with the inspections locations, then the corresponding id
numbers etc in rows. At the moment I am ctrl C ctrl V each bit of data from
the table into the form (each completed form is then exported and recorded
for analysing, the process repeats).
I then input the inspection data into the form, copied from regular emails.
Ideally I would be able to choose the location from the drop down list, then
the various fields with data in automatically fill in. I'm not familiar at
all with Access (new job and all that), but have a fair amount of computer
literacy.
I'm using Access 2003.
Thanks for any help,
Profqwerty