Searching by Zipcode

[dragonmanUSMC]

I have a form that allows us to view all of our customers in our customer database, (one customer at a time) is there a way to create a form that ask the user to input the zipcode of the company they want to see and then open the customer form that will go to that customer?

 

[THWatson]

dragonman72
Would a combo box do what you want?

If so, just use the combo box wizard to put it on your form. All the zip codes you have on record will be in the combo box, and you select the one you want.

Tom

 

[TheAceMan1]

How are ya dragonman72 . . . . .

To open the form, see the 4th arguement of [blue]docmd.OpenForm[/blue].

See Ya! . . . . . .

 

[dragonmanUSMC]

Thank you for the replies, the zipcode in a combobox really isn't what i'm wanting to go with, I will try the argument as suggested by TheAceMan1