Record Display

[Guest]

I have a payment input form which is able to check double payment. But how
can I have the previous / relevant information shown on the screen if double
payment encountered during the input? Please help

 

[Arvin Meyer [MVP]]

The most obvious way to check during input is to use DLookup, or build a
recordset to do the lookup in the BeforeUpdate event of the field you want
to check, or, if you want to check multiple fields, use the BeforeUpdate
event of the form. The reason for using this event is that it can be
cancelled and you can undo the duplicate (you still use an autonumber
though)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access