M
M Carrano
Hello,
I am trying to think of a way to have a data entry clerk
notified of a possible duplication before they finish
entering data onto the form.
Specifically I would like the clerk to enter the first 4-5
fields and after the after_update event in the 5th field
for it to run a query based on what has already been
filled in. If there is a duplicate I want to be able to go
directly to that record and roll back the entry already on
the form. If there is no duplicate I want to return to the
first form to allow continued data entry. I was thinking
that the after_update event could open another form based
on a duplicate search query. I would possibly use command
buttons to affect the next action (Roll-back or return to
form.)
Am I on the right track or is there and easier way of
doing this?
Thanks for any help!
Marc
I am trying to think of a way to have a data entry clerk
notified of a possible duplication before they finish
entering data onto the form.
Specifically I would like the clerk to enter the first 4-5
fields and after the after_update event in the 5th field
for it to run a query based on what has already been
filled in. If there is a duplicate I want to be able to go
directly to that record and roll back the entry already on
the form. If there is no duplicate I want to return to the
first form to allow continued data entry. I was thinking
that the after_update event could open another form based
on a duplicate search query. I would possibly use command
buttons to affect the next action (Roll-back or return to
form.)
Am I on the right track or is there and easier way of
doing this?
Thanks for any help!
Marc