filtering completed orders

[scottappleford]

hi

is there away to filter rows when certain values in three different tables are the same. e.g. it is a stock control db - so when goods orded = goods in = goods taken - can this then be filtered automatically to hide rows and avoids congestion on the user interface (form)?

thanks

scott

 

[pafcpilgrim]

You could have a form with different buttons and then update the forms filter when each one is clicked.

If you goto the help file in Access and type in form Filter this will tell you what to do and should work fine.