Angello Pimental
Registered User.
- Local time
- Today, 11:25
- Joined
- May 9, 2001
- Messages
- 92
Using code, how do I get access to look up a value in a table based on what a user has selected in a combobox?
Before you answer, let me explain a bit further, as this problem is not as easy as it sounds.
I have a form which is used to add new records to a database. Whatever information a user enters onto the form is saved as a new record on a table.
In order to make entering information easier for the user, I want the user to be able to select a value from a combobox, which will then fill in a few other values based on what the user has selected.
These values are "Standard Information" that comes from a table(location). This information is not necessarily the correct information for the new record. So the user can then edit this "Standard Information" to what he/she needs before saving it to the table(records).
Basically, I need code that queries from Table1, then after information is completed, saves to Table2
Any help would be greatly appreciated.
Thanks,
Angelo
Before you answer, let me explain a bit further, as this problem is not as easy as it sounds.
I have a form which is used to add new records to a database. Whatever information a user enters onto the form is saved as a new record on a table.
In order to make entering information easier for the user, I want the user to be able to select a value from a combobox, which will then fill in a few other values based on what the user has selected.
These values are "Standard Information" that comes from a table(location). This information is not necessarily the correct information for the new record. So the user can then edit this "Standard Information" to what he/she needs before saving it to the table(records).
Basically, I need code that queries from Table1, then after information is completed, saves to Table2
Any help would be greatly appreciated.
Thanks,
Angelo