Query if price is not null

[Simon]

i have a contiuios form that shows a list of products a comapny sells
it is based ona query at the moment

IT shows the following
ProductID
ProductName
RetailPrice
TradePrice

Not all products have a trade price, on the form i want a tick box or
somthing that i can click and it will then remove all the products in
the query that do not have a TradePrice

CAn any one ponit me in the right directions

Thanks

 

[Arvin Meyer [MVP]]

Use a button or checkbox and 2 separate queries as the recordsource for the
form. You'll need to put the button or checkbox in the form's header, then
use some code like:

If Me.Checkbox = True Then
Me.Recordsource = "Query1"
Else
Me.Recordsource = "Query2"
End If