I have a form called SD

I would like it to open automatically when
text box [balance]in form SG is <1

Can I use an IIf statement?

Cheers

If SG![balance] < 1 Then
DoCmd.OpenForm "SD"
End If

You could place this on the AFTER UPDATE event of control [balance] or maybe on the CURRENT event of the form SG