Viewing Information

J

Jae Hood

Right now I have a form setup to view customer information by record.
What I would like to have is a combo box where the Customer Name is and have
it display their contact info when I pick one, instead of having my end users
scroll through 87 records to find the customer they're looking for.

I thought this would be easier then it turned out to be, I must be
forgetting something fundamental.
Thanks for the help!
 
R

Rick B

The combo-box wizard will build this for you. I think the very first screen
that pops up gives you three options for how the box should work. One of
thos options is to find a record and display it.

Just add a combo-box to the top of your form and use the wuzard to help you
build it.
 
J

Jae Hood

I've gotten the combo wizard to look up the customer name.
Now I created a select query inside that form to add all the customer info
fields such as address phone fax etc...
Now i'm back to where i started with the 87 records...
If I add those fields during the combo wizard I end up with a combo box the
width of my screen with all the info fields in the box.
I was hoping that when i added the query, i would select a customer, and all
of his info would be placed into the text boxes.
Instead its only the info of the first customer, if i want the other
customers i have to manually scroll through the records.

thanks again for the help
 
R

Rick B

Huh?

You have a form.

It is based on a query.

It contains all the fields for your clients.

You can scroll through the records.

Correct?

Okay, now add a combo-box. Select the third option from the first
selections. Add one key field to the box (cutomer name, or customer
number). That's ALL.

Open your form in form-view.

Click the drop-down arrow and find the cutomer you want. When you click
that customer, the form will move to their record.
 
J

Jae Hood

Working now
I guess I needed you to to hold my hand through this one Rick.
Thanks alot!
 
Top