Duplicate in last 100 Orders

A

aMack

I need to generate a warning that a [Container#] has been entered within the
last 100 orders [REF#]

I need the user to then choose whether to accept the entry or re-enter the
data.

My assumption is this code can be entered on the from at the "After Update"
event.

Suggestions please.
 
K

KARL DEWEY

UNTESTED UNTESTED
Have "After Update" event call macro with this condition to display message --
(SELECT TOP 100 Count([Container#]) FROM YourTable HAVING
[YourTable].[Container#] = [Forms]![YourFormName]![YourTextBox] ORDER BY
[REF#] DESC) > 1

If this will not work then use DCount >1 in condition with all the required
syntax.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate in Last 100 Records 5
Duplicate in last 100 records 3
find duplicate in last 100 records 3
Validation Rule on form 2
Problem with code to catch duplicate Primay Key 22
Preventing duplicate value data entry 4
checking duplicate values on data entry 4
Cancel insertion/delete last record 4

Top