search for records

[moose]

On my form i have a "customer" combo box, and for each customer, there are many products contained in "product subform".
What i want to be able to do is put in a textbox with a search command button so that a user can enter a product description and search for it by clicking the command button. Also i want it to be possible to put in a part of a description followed or preceeded by a wild card to search for records containing specific text. Please could you give me the code i need to use and instructions for an idiot as i am having trouble getting to grips with the terminology used by some members.
thanks,
Moose

 

[Jack Cowley]

I might suggest that you created 'synchronized' combo boxes. First combo box you use to find your customer. The second combo box is then limited to the Products and Product descriptions for that customer. As the user starts to type in the description of the part the combo box will find the closest match as you type. Once they find it and hit enter the appropriate records will be displayed in the subform. You will have to be sure that your Master/Child links are correct in you Subform so that this scheme will work.

Oops! Forget to give you this article on how to create the synchronized combo boxes...
http://support.microsoft.com/support/kb/articles/Q209/5/76.ASP?LN=EN-US&SD=gn&FR=0&qry=q209576&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

[This message has been edited by Jack Cowley (edited 07-17-2001).]

 

[moose]

thanks for the reply, but what i need to do is put in a part number (not knowing the customer) in order to find the item and all it's details including customer. at the moment i can search for an item by going to the customer first but sometimes we need to find an item when the part number is all the info i have got.