Tick box when query value is not null

[clare_voiant]

Hello again,

I have a query that checks postcodes against a list of 29000 postcodes. The query runs (via a macro on_exit) when the postcode is typed into the data entry form and opens on the screen in all its its glory to display the answer.....
But (and there's always a but!!!)

I dont want the query to be visible, I have a yes/no tickbox that i want ticking if the value of the query is not null.

any ideas?

your help, as always, is very much appreciated.

Clare

 

[Andrew Fergus]

Hi Clare
You can determine whether or not the query has records or not (the null condition) but building a 2nd query based on the 1st query. The 2nd query is a count of the records returned in the first query except it returns a nil value instead of null. You can then test for the =0 or <>0 condition with your check box.
HTH, Andrew.