Inquiring on Access

[Jon Gustafson]

I am building a form and I have a question. One of my
forms is a list of all of the customers for a particular
business. What I want to be able to do is select the
Customer's name from a drop-down list and then be able
to "inquire" to get all of the rest of the data for that
customer on the form. I do not want to have to keep
pushing the next button or figure out what the record
number this customer is.

This seems like it would be easy to do, but I am
struggling with it.

thank you

 

[Gary Miller]

Jon,

The ComboBox Wizard can create this for you. On your
controls toolbox make sure the wizard is on and then drop a
combobox onto the Header of your form. When the wizard
launches, choose the option to 'Find a record on my form
based on the value I select'.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Jon Gustafson]

Thank you so much Gary - I knew it had to be easy to do!

Jon