Help using query for record lookup?

[jstevanus]

I have a form with a subform. The subform lists part numbers with their descriptions. However, the same part may be in several different records. I made a user-defined query which allows the user to enter a part number, and the query then shows a list of IndexID numbers which is the primary key for the main form and is used to link to the subform. So, for example, I enter 12345 for the part number in the query, and it shows a list of IndexID's like 5, 100, 12. Which means that part number is in each of those records. I want the user to be able to select from the results (like the 5, 100, 12) and have that record be displayed. Any ideas? I've searched everywhere for a solution, know little about VB, and will listen to any suggestions. Please help...


Josh Stevanus
ifjstevanus@yahoo.com

 

[le888]

See this thread ...

http://www.access-programmers.co.uk/forums/showthread.php?t=60207&highlight=search+form

There is an example " Search Example 2000", maybe this help.

Le