View Single Post
Old 07-12-2019, 02:41 PM   #4
Newly Registered User
Join Date: May 2018
Location: USA baby
Posts: 2,027
Thanks: 38
Thanked 642 Times in 591 Posts
MajP has a spectacular aura about MajP has a spectacular aura about
Re: How to make a text box to perform as a combo/list box

However I still need the value to be saved to the control source. Currently I have the control source of the text box filled with the dlookup function, and it is retrieving the correct value, I now just need a way to have this value saved to the field I need it to be saved to when I save the record
If I understand this correctly, then simply do this in the forms on current event instead of the controls recordsource. Bind the control to the correct recordsource. In the forms on current event something like

if isnull(me.someTextbox) then
  me.someTextbox = yourDlookupFormula
end if
MajP is online now   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
machinetech (07-15-2019)