lacampeona
Registered User.
- Local time
- Today, 02:52
- Joined
- Dec 28, 2015
- Messages
- 392
Hello experts,
Is it possible being on main form and tell to access to check if some value exist on subform and if the data exist prevent from user to enter this data again?
I try something with DCount and Lookup and I get lost in strings......I mean I manage to check only that if my last entered record contains that value. i need to check all the entries not only the last entered record.
I need to prevent user to enter specific value two times. all future entries can be what ever want the user but only specific value must be entered once.
Example
I am on form A and I want to enter some data that will be shown in subform datasheet view. lets say subformB
On my form A I want to enter data in field name Name.
lets say i want to enter data: ball, orange, apple,ball, kiwi, watermelon, kiwi, orange...
my problem is now: how to make that value ball can be entered only once? all other values can be enteted multiple times.
how to tell access that he has to check all the data on the subform? access must check all the records? if field name on subform contains value ball i want to trigger some message to the user that he cant enter value ball again becouse this value already contains record ID1.
i get lost in strings and ideas....i manage to check the last entered record but i need to check all the records and prevent entering special value.
Thanks in advance
Is it possible being on main form and tell to access to check if some value exist on subform and if the data exist prevent from user to enter this data again?
I try something with DCount and Lookup and I get lost in strings......I mean I manage to check only that if my last entered record contains that value. i need to check all the entries not only the last entered record.
I need to prevent user to enter specific value two times. all future entries can be what ever want the user but only specific value must be entered once.
Example
I am on form A and I want to enter some data that will be shown in subform datasheet view. lets say subformB
On my form A I want to enter data in field name Name.
lets say i want to enter data: ball, orange, apple,ball, kiwi, watermelon, kiwi, orange...
my problem is now: how to make that value ball can be entered only once? all other values can be enteted multiple times.
how to tell access that he has to check all the data on the subform? access must check all the records? if field name on subform contains value ball i want to trigger some message to the user that he cant enter value ball again becouse this value already contains record ID1.
i get lost in strings and ideas....i manage to check the last entered record but i need to check all the records and prevent entering special value.
Thanks in advance