Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

help with validation in tables 1

Status
Not open for further replies.
stavro

stavro

Technical User
Joined
Oct 16, 2008
Messages
4
Location
GB
how do I combine data from field 1 (names) field 2 (dates of birth) to show duplicate entries when both fields are duplicated
 
Sort by date Sort by votes
Do you mean you wish to look up whether the fields are duplicated? If so, here is an example of one method:

Code: 
SomeFieldVar=Nz(DlookUp("SomeFieldNameHere","TableNameHere","DOBFieldName=#" _
   & Me.DOBControlName & "# AND NameFieldName='" & Me.NameControlName & "'"),"Not matched")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question Question
Help With Search Form Results
Replies
15
Views
1K
caykamanj1966
caykamanj1966
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
PrimoSteve
  • Locked
  • Question Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
947
PrimoSteve
PrimoSteve
TrekBiker
  • Locked
  • Question Question
Running query with parameter from Inputbox
Replies
8
Views
1K
TrekBiker
TrekBiker
BJZeak
  • Locked
  • Question Question
Struggling with finding an answer to a simple question
Replies
5
Views
964
BJZeak
BJZeak

Part and Inventory Search

Sponsor

Back
Top