Hi all,
I wonder if you anyone can help. I am using a modified version of the Northwind database and now just tweaking it slightly. I have my tabs along the top, one of which is 'Products'. When this tab is clicked a form (frm_productsmain) is called into the main window displaying my products. The form itself displays a datasheet (frm_productsdatasheet).
I'd like the datasheet to NOT display any products where the stock level (a calculated field) is 0.
Where would I do this? Is it done directly on the datasheet?
As part of the macro built into the Products tab I have a condition where any products that are discontinued are not displayed. This works fine as:
[Discontinued]=False
Thanks for any help you can provide. This really has me stumped.
Cheers
David
I wonder if you anyone can help. I am using a modified version of the Northwind database and now just tweaking it slightly. I have my tabs along the top, one of which is 'Products'. When this tab is clicked a form (frm_productsmain) is called into the main window displaying my products. The form itself displays a datasheet (frm_productsdatasheet).
I'd like the datasheet to NOT display any products where the stock level (a calculated field) is 0.
Where would I do this? Is it done directly on the datasheet?
As part of the macro built into the Products tab I have a condition where any products that are discontinued are not displayed. This works fine as:
[Discontinued]=False
Thanks for any help you can provide. This really has me stumped.
Cheers
David