IF all records in a form are null, statement

[chris_visible]

How can I use VBA to find if a field in a continuous form is null in any row.
I can find the first row using the following:

If me![Combo13].ListIndex = -1 Then

I would like to know how to do this for a set of records and express if any are null Then …….

I want this to use in an IF statement that checks whether a user has entered a value in every row of a form.

Any help would be great.

Thanks

 

[Pat Hartman]

Forms don't "own" rows. Forms display a set of records from a recordset. If you want to perform an operation on a set of records, use a query. It does not make sense to run this query from an event on a continuous form since each time you scroll to the next record, you could trigger the query to run again.