machinetech
New member
- Local time
- Today, 17:20
- Joined
- Jun 10, 2019
- Messages
- 7
I want to have a text box that auto-populates with a value its pulling from a query. I could do this with a combo box and have the record source using the dlookup function. However I do not want the user to have to select this value from the combo 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.
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.