Find the first record in form's source table where a specified field is null

**Iain** · 01-12-2016, 05:01 PM

I wish to write some code that will:

- search the form's table when the form is opened;
- find the first record in the table where a specified field is empty, then;
- populate a set of text boxes with the data from each of the fields in the record

I am guessing that this can be achieved with a SELECT statment in one of the form's property boxes but I'm unsure which property box to use and how to construct the statment.

Can anybody suggest how I might go about this?

**Iain** · 01-12-2016, 05:18 PM

Only Idea I have at the moment is something like:

Code:

Dim Rst As recordSet

  Dim f As Field
  
  'Current Record set
  Set Rst = CurrentDb.OpenRecordset("tblWebMeetingData")
  
  'Holds current fields data
  Dim fieldData
  
  'With Rst
      'Do Until Rst.EOF
         For Each f In Rst.Fields
              If IsNull(f.Value) Then
                  MsgBox ("Field Name: " & f.Name)
              End If
         Next
      'Loop
  'End With
  
  Rst.Close