Sub form Entries

  • Thread starter Maqza via AccessMonster.com
  • Start date
M

Maqza via AccessMonster.com

Hi!
I have a sub form in that there is no unique or primary key, but I want to
stop duplicate entries
In main Form only using Unique Date

e.g.
eno ename
10 John
20 Denny
10 ( this is duplicate entry)

Please help me.
Thanks and Regards
 
R

ruralguy via AccessMonster.com

I believe "SELECT DISTINCT eno" in your query should work for you.
 

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

Prevent duplicates in sub form 1
Access Daily Entry with multiple entries per field 0
Unique key allows entry in form 4
Duplicate record in Form and Subform 0
Duplicate entries 6
Duplicate sub form last record 6
Duplicate entry 1
Unbound form + duplicate values error message 10

Top