UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Dlookup value Question    
 
   
Quicksilver2002
post Jan 31 2007, 07:22 PM
Post #1

UtterAccess Veteran
Posts: 306
On my form I have a text box whos Control source is set to "=DLookUp("[Inspection]","qryInspectionUsed")" When a employee selects a value from a combo box this value changes. This works, but I need to figure out how to get that value in the textbox entered into the table when the "SubmitData" button is pressed. Can this be done?
Go to the top of the page
 
+
Jack Cowley
post Jan 31 2007, 07:34 PM
Post #2

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
Without knowing more about the value you are saving I am not sure you should save it as it sounds like it already exists in the db. Anyway, here is how to do it... In the After Update event of the combo box:

Me.NameOfControl = DLookUp("[Inspection]","qryInspectionUsed")

hth,
Jack
Go to the top of the page
 
+
Quicksilver2002
post Jan 31 2007, 07:58 PM
Post #3

UtterAccess Veteran
Posts: 306
thats what i needed. Thanks for steering me in the right direction!
Go to the top of the page
 
+
Jack Cowley
post Jan 31 2007, 08:06 PM
Post #4

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
You are most welcome!

Jack
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 09:13 AM