Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-24-2010, 07:09 AM   #1
Djblois
Newly Registered User
 
Join Date: Jan 2009
Posts: 590
Thanks: 0
Thanked 0 Times in 0 Posts
Djblois is on a distinguished road
Dlookup not working

I am trying to use this dlookup as my Control Source for a textbox:

Code:
DLookUp("Customer","tblCustomer","Customer_ID = " & [Forms]![frmSellingMain]![tbCustID])
I cannot figure out why it is not working. The syntax looks correct and I checked the spelling over and over.

Djblois is offline   Reply With Quote
Old 02-24-2010, 07:12 AM   #2
SOS
Registered Lunatic
 
SOS's Avatar
 
Join Date: Aug 2008
Location: Somewhere between here and there
Posts: 3,517
Thanks: 2
Thanked 59 Times in 54 Posts
SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light
Re: Dlookup not working

If CustomerID is a text value you would need:

=DLookUp("Customer","tblCustomer","Customer_ID = " & Chr(34) & [Forms]![frmSellingMain]![tbCustID] & Chr(34))

and make sure the equals sign is there.
SOS is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Working days/hours in a query eddie442 Queries 3 11-20-2008 01:28 AM
Help with DLookup function in form oZone Forms 9 10-29-2008 07:53 AM
DLOOKUP not working monvani Queries 6 10-17-2008 12:08 PM
Help with DLookup - not working jdp103 Forms 1 02-26-2005 08:14 PM
[SOLVED] Dlookup Problem grahammm Forms 2 02-14-2005 05:54 AM




All times are GMT -8. The time now is 12:44 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World