Field validation

[needadvice]

I have a table with a numeric field. The value entered into that field must not be higher than a related field. How do I put a restriction on the table to prevent entering a value higher than the related field.

 

[willir]

needadvice

You can use the DMax function for the Before Update event...

Winging it...

Dim lngTest as Long

lngTest = DMax ("[lngSecondField]", "YourTable", "YourWhereClause")

if lngTest <= Me.lngFirstField then
   MsgBox "Must be higher than " & lngTest
   Cancel = True
   Me.lngFirstField.SetFocus
end if

Read up on Dmax for more info...
Richard