confused

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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...
 
Back
Top