Spørg før record forlades.

hi Morten
Try the before update event

In this event you should be able to validate the fields and set cancel to False if any fail

Sidder ikke med det pt. men er ret sikker på jeg testede  både form_beforeupdate... samt afterupdate.
Problemet er at dette trigger en hændelse så snart der indtasts i en ny record. Jeg har brug for at hændelsesforløbet starter når man går ud af recorden.

Hvorfor vil du først validere når man går ud af record?
Med lidt bagvendt kode, kan du bruge 'current' til dette. Du kan evt. bruge noget a la nedenstående til at angive, hvilke værdier, der skal checkes
  if me.dirty then 'checker om record er ændret
    if me.feltderskalcheckes.value < 0 then
      ...
    endif
  endif

Men hvorfor ikke validere det enkelte felt, når man retter i det?
Dette kan du evt. styre via det enkelte felts valideringsregler eller via VB hvis situationsafhængigt.

In the before update event the record has not yet been written to the table so you can make any alterations necessary if the data is not valid. In the AFTER update event the data HAS been written to the database so if you now validate you cant revert to the original (old) data.

Sometimes it is necessary to validate the whole form/fields at the same time because som fields may be depandant on values in other fields.

this is taken from Access Help

You often use the BeforeUpdate event to validate data, especially when you perform complex validations, such as those that:

Involve conditions for more than one value on a form.


Display different error messages for different data entered.


Can be overridden by the user.


Contain references to controls on other forms or contain user-defined functions.

And this is an example also taken from Access Help. Note that setting Cancel = True cancels the update so that data can be changed BEFORE the data is written to the dB.

Private Sub ProductName_BeforeUpdate(Cancel As Integer)
    If(Not IsNull(DLookup("[ProductName]", _
        "Products", "[ProductName] ='" _
        & Me!ProductName & "'"))) Then
        MsgBox "Product has already been entered in the database."
        Cancel = True
        Me!ProductName.Undo
    End If
End Sub

whats the status moba?

Terry sender du lige et svar - jeg bruger before update. Gjorde jeg også før, men kunne ikke få det til at spille fordi der lå en me.requery på et af felterne. My bad...

tak

.

thanks moba