Preventing Duplicates - Access Developers


	Back to Access Developers Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Preventing Duplicates

Vicent Mnaya

5 years ago

How can I prevent duplicates in combo box
example
I have
Tables
IncomeT , DistributionT and ExpenditureTypeT tables.
Relationships
IncomeT related to DistributionT (IncomeT a parent - one to many)
DistributionT related to ExpenditureTypeT (DistributionT a parent - one to many)
Forms
IncomeF and DistributionSubF.
DistributionSubF is a sub form of IncomeF where one income can be distributed into multiple expenditure types.
DistributionSubF contain ExpenditureType combo box to select the type of expenditures for the earned income.
What I want?
When I select one expenditure one time, if a I accidentally select the same expenditure next time, i want to get an alert that this expenditure already chosen.
Help please.

	Vicent Mnaya OP @Reply 5 years ago

	Kevin Robertson @Reply 5 years ago
You could use DLookup in a BeforeUpdate Event.

	Richard Rost @Reply 5 years ago
I've got a video coming up on this topic. Stay tuned.

	Vicent Mnaya OP @Reply 5 years ago
Thank you.

	Richard Rost @Reply 5 years ago
Due to the holidays, I may not get to this until after the 1st, but it's on the list. If you're in a hurry, I do cover this in Access Developer 27.

	Vicent Mnaya OP @Reply 5 years ago
I am not hurry. I'm now at developer 4 , I will finish all developer lessons. For now I will continue with developer 5 while waiting the release of the video.

	Richard Rost @Reply 4 years ago
The Extended Cut for this video deals with a very similar issue: Subforms

	Vicent Mnaya OP @Reply 4 years ago
Richard i would like to remind you about the video you promised to release on january, i have not got the solution to my problem i'm still waiting

	Richard Rost @Reply 4 years ago
Indeed. While I never promise a time frame (I learned that lesson years ago) the video is overdue. I'll put something together soon.

	Richard Rost @Reply 4 years ago
Here you go, Vincent: Prevent Duplicates

	Vicent Mnaya OP @Reply 4 years ago
Thank you.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developers.

Next Unseen

New Feature: Comment Live View