query using dynamic input?

[jmbcreative]

I have a form with a combo box that selects records. Each of these records has a control number like "243". There are other records that corespond to each of those with control numbers like "243a, 243b, 243c" and so on. All I need to do is have a text box show the control numbers of all of the records that are attached.

For example, I select the system "Booger" in the combo box. (The combo box is already grabbing three columns of information from the table, one of those being the control number) I simply need to display the sub-records control numbers.

This, I'm sure, requires a simple SQL statement, but I have no idea were to start. Any Ideas?

 

[jmbcreative]

Basically, what I need the build event for the text box to do is the following;

refer to combo_26 for input
return controlID for all ControlID's containing number from tableA


I beleive that would be the best way to accomplish this. Anybody know how to do this with VBA or have a better idea?

 

[jmbcreative]

Aight, so I just created a subform of a query and linked the system ID's. I guess that will work for me.