View Full Version : IF all records in a form are null, statement


chris_visible
02-27-2002, 01:16 AM
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
02-27-2002, 04:53 AM
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.