G
Guest
I have a table called "TRACKING" (My primary key uses autonumber)
The form that uses this table is called "PERMIT TRACKING"
On the form "PERMIT TRACKING", I have a text box "Permit Number" (indexed
with duplicates - this is the way I want it)
However, I would like for the user to be alerted that the entry already
exists: do you want to continue? if a duplicate is entered into that field
on the attached form. I read the answer that you provided to jennyhuffman71,
but I'm having difficulty with the code.
In the answer provided to her, it references a query. Is that just a name,
or is there an actual query? Please forgive my nievity, but I don't know
anything about code, I'm kind of on my own to figure this out. Any help
would be greatly appreciated.
The form that uses this table is called "PERMIT TRACKING"
On the form "PERMIT TRACKING", I have a text box "Permit Number" (indexed
with duplicates - this is the way I want it)
However, I would like for the user to be alerted that the entry already
exists: do you want to continue? if a duplicate is entered into that field
on the attached form. I read the answer that you provided to jennyhuffman71,
but I'm having difficulty with the code.
In the answer provided to her, it references a query. Is that just a name,
or is there an actual query? Please forgive my nievity, but I don't know
anything about code, I'm kind of on my own to figure this out. Any help
would be greatly appreciated.