lookup question


M

Mike106

I have a form with fields bound to table1. Field1 is a combo list that is populated by values from field1 in table2. Tsble2 has other fields that correspond to fields in table1. When I am adding a new record in talbe1 and select a choice in the field1 combo list that would have the same value in field1 in table2, I would like to have the corresponding values from the corresponding table2 fields to appear in the form but not necessarily accepting the values before I commit the record to the table. How do I accomplishthis? I am new to VBA.
 
Ad

Advertisements

fx3

Joined
Feb 17, 2013
Messages
13
Reaction score
0
"appear but not accept"... not sure what you mean....

you can "hide" certain columns (e.g. the key column) in the combobox, so that the combobox is still bound to column 1 but shows column 2.

If by "appear but not accept", you mean you want a way to "save" your record manually, you could also accomplish it in another way - accept the data, but have the ability to "undo"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top