Search for ID using Description

[chasemhi]

Hi all, first time posting and thanks for the help.

I have an MS Access Orders database (http://bit.ly/fxKsgG) and the customer name is displayed on a form, but the actual value behind the field is the customer ID. I want to be able to search for a customer by name. How can I do this if the field is based on the ID and not the name? I toyed with a text box that took the user-entered value and ran a query to return the customer ID, but I couldn't pass this value on to the form to display the customer's record.

Thanks again.



Chase

[alansidman]

Chase,
Try this:
http://www.datapigtechnologies.com/f...tomfilter.html

Alan

[chasemhi]

Thanks for the great link Alan. I will definitely use DataPig as a source of learning. Unfortunately this tutorial didn't help me with my search since I don't have the form based off of a query as the tutorial does. I will try playing with the customer ID to see if I can't filter the form based on the customer ID that is controlled by a dropdown menu.

Chase

[pkstormy]

A couple of examples which may help (from the Code Repository section):

(popup search form with alphabetical buttons - shows listing of customers, search by first or last name, click the 'A' button to see all names that begin with A, B button to see all names that begin with B, etc...etc... Once a customer is clicked, the data form opens based on that customerID)
https://www.accessforums.net/code-re...ally-7688.html

(Different search methods)
https://www.accessforums.net/code-re...hods-7689.html

(Another search method but includes data entry coding to find duplicate entries)
https://www.accessforums.net/code-re...ames-7680.html