Empty Query Test? & AutoNumber Test?

[m82palmer]

Hello I’m after a bit of help again.

a) Is there a way to check to see if a Query is empty? – IE I have a form that takes information from a Query, and I don’t want this form to load id the Query is empty.

b) Is there a way of checking with statement if a field still says “(AutoNumber)”



Cheers Michael

 

[Calvin]

use a dlookup method to count the number of records in your query, if the record count is 0 then don't open the form.

Search this forum and Access Help files for info on Dlookup.

 

[WayneRyan]

m82,

Use DCount instead.

Wayne

 

[m82palmer]

Thanks

i ended up using DCount and i only had to mumble abuse at my PC a few times ...everything worked fine after i mumbed something about using it as door stop

Thanks again