If Data is Duplicate, just alert user

[SDS100UK]

Hi,
(AccXP)

I have a table with a CreditCardNumber field in.

This table stores data on bookings. There is a unique customer number, but this is only an internal number.

If a customer phones and places an order, what I need is for Access to check and see if this customer already exists. If so, then simply to alert the user to this and allow the transaction to continue.

Maybe if a msgbox could spring up with the record or customer number of the previous transaction.

What would be the simplest way to achieve this?

Many thanks in advance

Steven

 

[jksmi]

Hi, the simplest way would be to use a DLookup function - on a form it would look something like

If NOT IsNull(DLookup _
    ("CREDIT_CARD_NO", "LU_CUSTOMERS", "CREDIT_CARD_NO = " & me.YourIdControlName & ")) Then
    MsgBox "Credit card number exists"
End If

LU_CUSTOMERS being your customer look up table, CREDIT_CARD_NO being the field name in that table - if its a text field then add 's into the criteria, i.e "CREDIT_CARD_NO = [highlight]'[/highlight]" & me.YourIdControlName & "[highlight]'[/highlight]))
HTH, Jamie