confused

A

Arnie

how do i prevent a user selecting the next record until they have changed a
combobox ie Form changed by:

i have tried a message box and setting the focus on the combox but it does
it twice before going on to the next record.
 
O

Ofer

On the before update event of the form, check the value in the combo, if it's
Null then prevent the user from continue

If IsNull(Me.ComboName) then
MsgBox "Must enetr value in ..."
cancel = true ' wont move to the next record
me.ComboName.SetFocus
End If
 
A

Arnie

Ta just the job

Ofer said:
On the before update event of the form, check the value in the combo, if it's
Null then prevent the user from continue

If IsNull(Me.ComboName) then
MsgBox "Must enetr value in ..."
cancel = true ' wont move to the next record
me.ComboName.SetFocus
End If
Click to expand...
 
Top