Find Null

G

Guest

I am trying to use the FindRecord action in a macro to find any field that is
blank or null. In the find what I put =Null, Null and it gives me an error.
I don't care which record or which field it is I just have it as an error
checking field to make sure that there are not any null fields. I want to
set it to a button so I can just click a button and pull up any records with
any Null fields. I am new to Access so having a little trouble! Thanks for
any help
 
S

Steve Schapel

Eric,

I don't know about using FindRecord in this context, I've never tried
it. But you could make a query based on your table, and in the criteria
of one of ther fields, put...
Is Null
.... and run the query to see all the affected records.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top