check subform fields

damnnono_86 · December 28th, 2003, 10:18 PM

hi, how do i check if the fields in the subform is empty???

pls advice
nono

SerranoG · December 29th, 2003, 11:36 AM

Using a textbox as an example,

Code is in the main form:

Code:

   If IsNull(Me.sfrMySubForm.Form.txtMyTextBox) Then
      'Do something here with code.
   Else
      'Do something else here with code.
   End If

Code is in the subform:

Code:

   If IsNull(Me.txtMyTextBox) Then
      'Do something here with code.
   Else
      'Do something else here with code.
   End If

Use the real names instead of sfrMySubForm and txtMyTextBox.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division