Making Access forms only show records where data is missing

[stevey03]

I'm using Access 2000 and I'm trying to get this form only show records that have data missing form a particular field only. I don't know how to do this, does anybody know?

 

[Gastrifitis]

Re: Making Access forms only show records where data is miss

You need to create a query based on the information. I suppose you could change your form's focus to the query afterward, if you like. Base your query on the root table(s) that have the info and include all the fields you need to see. In Design view, the criteria for the field in question would be

=""

and in the next line down, the "or" line, you could put

=isnull

just to be safe. Or is it just isnull? Anyway, to change a form's focus, open the form in design view, turn on properties, and it's the first selection on the data card. Use the query you just made as the record source.

 

[stevey03]

Re: Making Access forms only show records where data is miss

Thanks, that's helped a lot. Didn't think of that at first.

Thanks again!