Jan 31 2007, 07:22 PM
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?
Jan 31 2007, 07:34 PM
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")
Jan 31 2007, 07:58 PM
thats what i needed. Thanks for steering me in the right direction!
Jan 31 2007, 08:06 PM
You are most welcome!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here