Auto fill

D

Diogo

Ok
I know this most be a recurrent doubt but I couldn't find anything that
would suite my needs.

I have a combo box that a user uses to enter a store name. The next field is
another combo box that the user uses to enter the store code.
How can I make Access auto fill the store code field?
In the row source control of the first combo box I have a select that
selects the store name from a table. This table has the names and the codes
of the stores.
How can I make a query or code that sees the apropriate code in the stores
Table and auto fills the code in the forms second combo box? Based of course
in the name that the user selected in the first combo.
I need this code to update value in case the user dicides to change the
store name in the middle of his filling form.
 

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