Go Back   Access World Forums > Microsoft Access Discussion > Forms

View Poll Results: Dlookup can't update txt box
ComboBox 0 0%
Dlookup 0 0%
Voters: 0. You may not vote on this poll

Thread Tools Rate Thread Display Modes
Old 07-23-2014, 05:11 AM   #1
Newly Registered User
Join Date: Jul 2014
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
carlosd is on a distinguished road
Question Dloolup can't update txt box


I have a new Customer Form(Profile) and I have the same customer data in another Table(Contacts).

I create a Dlookup... the system pull the data correctly from my Combobox but when I try to close the form, the system display a error like: The first name is empty...

I think the Dlookup need something to update the new table.

This's my actual Dlookup...

=DLookUp("[Last Name]","Contacts","[Combo378]='" & [Forms]![PROFILE]![Combo378] & "'")

carlosd is offline   Reply With Quote
Old 07-23-2014, 05:28 AM   #2
Wino Moderator
pbaldy's Avatar
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,245
Thanks: 13
Thanked 4,102 Times in 4,034 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Dloolup can't update txt box

I moved your thread out of the introductions forum. Might this help?

Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote

combobox , dlookup access forms , updatable

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DLoolup Show Results Values in Texbox on its own line multiple columns gcoaster Forms 7 04-12-2014 03:45 PM
Update from Outlook to Table works but fails to update Form JoyP Forms 4 03-09-2012 02:22 AM
Update Query - uses selected record to make calculation and uses this to update all! DSLNVL Queries 3 08-01-2011 05:50 PM
Update Query - Update Duplicate value from Single Matching value from another table xxx Queries 4 06-14-2011 11:28 PM
UPDATE query (not update if certain critea exist in the destination table) homer2002 Queries 6 02-15-2003 02:15 PM

All times are GMT -8. The time now is 02:24 AM.

Microsoft Access Help
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