G
Guest
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
(e-mail address removed)
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
(e-mail address removed)