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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validate on two values

Status
Not open for further replies.
mikelev

mikelev

Technical User
Mar 23, 2004
223
0
0
US
I am trying to prevent the user from entering multiple counts for the same table (card table) on the same day.

tblSoftCount
InsertDate (general date)
Tablenum (text)

Would someone help me with a Dlookup? I want to place the lookup on the after_update event of the combobox with the table numbers. I tried and got this far.....

'check to see if the table has an entry for today
If (DLookup("[tablenum],[insertdate]", "tblSoftCounts",??? )) Then...

Many thanks

 
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
208
dhookom
dhookom
applestoapples
  • Locked
  • Question
Create duplicate rows based on Qty field
Replies
7
Views
72
Andrzejek
Andrzejek
Lamar Washington
  • Locked
  • Question
Programmatically send email using only OWA
Replies
2
Views
82
Andrzejek
Andrzejek
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
63
dhookom
dhookom
scubafrog79
  • Locked
  • Question
Loop through a datasheet and change cell value based on two other cells
Replies
4
Views
83
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top