G
Guest
I am using Access 2003.
I am working on creating a db for someone who is not familiar with access.
I am trying to make it super simple. I created a "look-up" table with 3
fields of data. My database (A) to store the information is linked to this
look-up table by the 3 fields: Field 1 for verification, field 2 to pick a
code from and field 3 a description of the code. When the operator open the
form to add data - it is a one to many type form with a subform from database
A. When the operator clicks on field two he will see the 3 fields listed
above. Using field one to locate the codes available for that item he will
then pick a code from field 2. What I want now is for field 3, for the code
chosen, to automatically be entered into field 3 on the form.
How do I accomplish this? Can this be done within Access without writing
code. My writing code knowledge is very limited. Can anyone help me??
Aurora
I am working on creating a db for someone who is not familiar with access.
I am trying to make it super simple. I created a "look-up" table with 3
fields of data. My database (A) to store the information is linked to this
look-up table by the 3 fields: Field 1 for verification, field 2 to pick a
code from and field 3 a description of the code. When the operator open the
form to add data - it is a one to many type form with a subform from database
A. When the operator clicks on field two he will see the 3 fields listed
above. Using field one to locate the codes available for that item he will
then pick a code from field 2. What I want now is for field 3, for the code
chosen, to automatically be entered into field 3 on the form.
How do I accomplish this? Can this be done within Access without writing
code. My writing code knowledge is very limited. Can anyone help me??
Aurora