find duplicate in last 100 records

  • Thread starter Thread starter aMack
  • Start date Start date
A

aMack

I need a message to appear on a form if the [Container#] matches within the
last 100 records [REF#].

Msgbox to read "This container was used on [REF#] - Verify Container Number
or modify your entry".

The user than should be able to acept the duplicate or change the
[Container#] data.

I assume this will be in the "After Update" event.

Help please.
 
You've already received answers from at least two of us.

Was there a problem with those answers?
 
aMack said:
I need a message to appear on a form if the [Container#] matches within the
last 100 records [REF#].

Msgbox to read "This container was used on [REF#] - Verify Container Number
or modify your entry".

The user than should be able to acept the duplicate or change the
[Container#] data.

I assume this will be in the "After Update" event.
Click to expand...


Your question was answered by two people yesterday.
 
I am not getting a refresh quick enough - it is days before I see my question
appear so I think it did not go through.
--
A MACKENZIE, CMA, MBA


Marshall Barton said:
aMack said:
I need a message to appear on a form if the [Container#] matches within the
last 100 records [REF#].

Msgbox to read "This container was used on [REF#] - Verify Container Number
or modify your entry".

The user than should be able to acept the duplicate or change the
[Container#] data.

I assume this will be in the "After Update" event.
Click to expand...


Your question was answered by two people yesterday.
Click to expand...
 
Back
Top