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 Westi 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
Oct 16, 2008
4
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
Help With Search Form Results 2
Replies
15
Views
377
caykamanj1966
caykamanj1966
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
645
Kennelbloke
Kennelbloke
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
485
PrimoSteve
PrimoSteve
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
572
TrekBiker
TrekBiker
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
530
BJZeak
BJZeak

Part and Inventory Search

Sponsor

Back
Top