Combo Box!!!

[little_rascals]

Hi, i need to create a combox box showing a list of my
customer names. When the user clicks on a particular
customer, he will be directed to the customer's
particulars page.

However, i was not directed to any pages after clicking on
a particular page.

Can somebody help me with this?
Are coding required?!
Thank You!!!

Cheers,
little_rascals

 

[Albert D. Kallal]

Try making the combo box with the wizard.

Place the combo box in that customer form, and select the 3rd option when
you make the combo.

 

[Guest]

?!!?
Is there a 3rd option when going through the wizard??

 

[Albert D. Kallal]

You should get the 3rd option when using a2000 or later.

If suing a97, for some bizarre reason unknown to me, the 3rd option DOES NOT
appear if your form is based on a query!

You can temporary change your form to a table, build the combo, and then
change the forms data source back to the query.

But, yes...there should be a 3rd option:

The 3rd option is:

"Find a record on my Form based on the value I selected in my Combo box"

You don't mention what version of ms-access. Also, this wizard, and 3rd
option only appears for a bound forms. So, fire up that main customer form,
or whatever, and try the wizard. Just to note, this combo box is to be
placed on that main edit form.

I prefer making my own search forms, but the combo box for small files is
ok.

And, after you get the combo working, you can read my thoughts on how
searching should work!

http://www.attcanada.net/~kallal.msn/Search/index.html