I have a form with several subforms. The subforms allow the user to enter multiple entries all relating back to the main form. I would like the focus to move from the first field in the subforms to the next field on the main form when there is a null entry.

I have tried code like this, but did not get it working and need some help.

If [field] = Null Then
Forms!MainForm!NextField.SetFocus.

As always, I am grateful for your help.

Peter Paul

use
IsNull(me.[Field]) then Forms!MainForm!NextField.SetFocus

or

Nz(me.[Field],"")="" then Forms!MainForm!NextField.SetFocus