Use a button to create a query on the fly

[DuWayne]

I have all (30) of my databases set up that contain manufacturing bom's. My form is set up, now I need to code a button on my form to open a msgbx with a combo box that brings up a list of all my databases. Another field to enter a serial no. of the bom, then have it to select the table, run a query that table and select (5) fields from that table. All tables are exactly the same. Query selects (5) fields: fbompart, fitem, fbomdesc, fbommeas, ftotqty. In fitem all the parts I want to pull out it has an "X" in the field. I want to create a report returning fbompart, fbomdesc, fbommeas, and ftotqty. At the top I want the table name and serial no. Can anyone help me to get started. Thanks in advance

[pbaldy]

Well, you would have to build the SQL of the query in VBA code, using a DAO QueryDef. The real question is why you have all the identical tables? This would be simple with a normalized table design.

[DuWayne]

The reason i have so many tables is that I have to pull the bom's out of an ERP program so I can look at all the components that make up our product.
If you can help me find a better way, I'm listening
Thanks for the reply
Merry Christmas