Can setfocus on a field error 2108

[SDL]

The code below says error 2108 must save field before setfocus?

All I want to do is check out the input field and if in error set the
cursor back on it after the MsgBox displays. In this case I read the
file and didn't find it.

If INVOICE_NBR1 = 0 Then
MsgBox "INVOICE NUMBER is not on file. Re-enter or enter NAME or
PHONE.",vbOKOnly
Me.INV_NBR.SetFocus

Any help would be great thanks.

[Rick Brandt]

SDL wrote:

The code below says error 2108 must save field before setfocus?

All I want to do is check out the input field and if in error set the
cursor back on it after the MsgBox displays. In this case I read the
file and didn't find it.

If INVOICE_NBR1 = 0 Then
MsgBox "INVOICE NUMBER is not on file. Re-enter or enter NAME or
PHONE.",vbOKOnly
Me.INV_NBR.SetFocus

Any help would be great thanks.

Use BeforeUpdate for your validation code and just set Cancel=True if it fails.
The control will never lose focus so resetting it is not required.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com