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

Top