Look up records using a combobox and textbox
Posted on 2013-05-10
I have an access form with a combobox and a textbox on it.
I have a table with 4 fields. Fields 1, 2 and 3 combined make up the primary key. Field 4 is a currency field.
The combo box uses Fields 1, 2 and 3 to look up a record. I want Field 4 of the record to be displayed in a textbox for editing. How do I do this? Thanks.