Unanswered: Simple question regarding textfields data source
I need to change the source of data that is being entered into a textfield in my form from one table to another. How would i do this?
I tried going to Data>Control Source>Expression Builder but when i select a field from a different table and run the form, all i get in the text field is "#Name?"
you're changing the control source of the txt box. the form doesn't recognize it (hence #Name?) because its not part of the form's data source. Try adding it there (at the form level) and it should work.