On my form I have a listbox (pulldown) and a textbox. The listbox is table/query , and it selects all 'number' fields from table main.
Once one of the numbers has been selected, I want the textbox to automatically update its value. The value should come from table main, the field 'title' corresponding to the number ID that was selected. Can I do this in the control source , and if so, what would be the line of code, because what I've tried doesnt work.