Hello everyone. I would like to know when placing an edit on a field of a form, where is the best place to do it? Now, if there is a problem, I want to be able to cancel the update. So, do I use the [Before Update] of the field or the [Before Update] of the form? Also, how do I cancel the update and set focus on the field when there is a problem?

For instance, I want to have a first name and last name field. So, I would like to check for the presence and set focus if there is a problem in the [before update] procedure of the form, but Access won't let me set focus there. Can anyone please help?

Thanks,

Chuck [RU1]

If you are checking on a new record, you use the Before Insert event.

If you are checking on an updated recoord, use the Before Update event.

If it is a new record, then jusr reset the offending field to blank, and set focus there.

If it is an updated record, then take the oldvalue and put it back in place of the new value.

HTH

mmcdonal

Those are the form events, not the text box or combo box events. It is better to check on the form events to my way of thinking.



mmcdonal

Okay, here is a little code. Focus may not be needed.

Dim sLName As String

If IsNull(Me.LName) or Me.LName = "" Then
   MsgBox "Please enter a last name.", vbCritical
   Exit Sub
Else
   sLName = Me.LName
End If

   'Use code here to check sLName for conditions.
   'If wrong,
       'Me.LName = Me.LName.OldValue
   'MsgBox "Wrong Value" etc and Exit Sub

If everything is okay, then none of the conditions will be triggered to exit sub, and the record will be saved.

Of course, you can also build data validation into the table, and Access will throw these errors and reset focus on the offending field.

I use the stuff above on SQL tables with no triggers.


mmcdonal