open query...

[rosito]

Hi all,
can i open 3 Queries with one (the same) criteria at the same time?
tnx

 

[ajetrumpet]

YES, you can.

 

[neileg]

You need to capture the criteria in a form so that it is visible to the queries when they run.

 

[rosito]

Adam & Neil, tnx ...
I try it...but i dont know how to do...this is stupid, but i have not enough knowledges and i think i discover the "hot water". Would you help me, plz...looking the attach file? I try to reduce my tables (this is old base - many files, many records, many fields ...from DBase)
tnx

 

[Jon K]

See the new form and queries in the database.

Since the part numbers are 13 digits long, I have used a combo box for the user to select a number instead of using a text box for the user to enter a long number.

The query "qryUnionParNom" is used as the Row Source of the combo box.
.

 

[rosito]

Gratefully, Jon K!