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!

DLookup Question

Status
Not open for further replies.
qad122

qad122

Technical User
Nov 14, 2002
12
0
0
US
Why would a DLookup statement cause a #Name? on the next row of an order entry, and that next row is blank?

Susan
 
Sort by date Sort by votes
Because it's looking for a value in one of the other fields in that same row, maybe. If that value is missing then the function says, "Hey, where's the data".

Paul
 
Upvote 0 Downvote
You are exactly right. I had the code in the default!
Duh!!! It took me all day to figure that one out.

-Susan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
132
BJZeak
BJZeak
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
63
dhookom
dhookom
vba__6229
  • Locked
  • Question
Dlookup on form not working
Replies
2
Views
52
dhookom
dhookom
billheath
  • Locked
  • Question
Dlookup problem
Replies
4
Views
75
billheath
billheath
meagain
  • Locked
  • Question
DLookup with Multiple Criteria 1
Replies
3
Views
74
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top