AnsweredAssumed Answered

Validate field on exit

Question asked by JamesHalliwell on Aug 31, 2012
Latest reply on Sep 2, 2012 by Sorbsbuster

Title

Validate field on exit

Post

Hi All

Please could someone help me out with a script in the onobjectvalidate i am scanning barcodes into a form i need to check if the first two charaters of the barcode begin with +H or +M

In access i achived this by putting in an after update event

If Left([Barcode], 2) = "+H" Or Left([Barcode], 2) = "+M"  Then Exit Sub
Beep
Cancel = True
Me.Barcode.Undo
End Sub

Please could someone help me convert this into filemaker script as i have only attended a one day course and scripts was not on it

 

Many thanks

Outcomes