Query Help

[merciless32]

OK,
I have 15 different tables and forms in my databse. I would like to build ONE query that will be attached to a button that filters the records according to a status field. This button would run a query that will display all records with an 'X' status. I would like to be able to put this button on every form and have it sort whatever form/table is currently active instead of building a query for every single form and table...

 

[mark curtis]

Well so long as your forms are built on a query and that query has the status field then you can:

1) Insert a combo box with the record source showing the status.
2) On_Change Event of the combo me.frmName.requery
3) In the underlying query reference the combo box in the status field criteria.

 

[mark curtis]

Pat,

The same thoughts crossed my mind and I guess instead of offering advice on the initial problem I should look at the bigger picture, like your good self!

I agree that the design looks to be the problem.