Unanswered: Populate field in table based on another field selection
I am creating a table that has minimal fields, which I will then use to create a form for the user. Essentially what I would like it to do is for the user to select a memo number from a drop down menu and based on the number they select the memo title field will auto populate. I have the memo number field set to combo box with the data being pulled from another table, however how do I get the title to auto populate.
If the table you are using for your combo box list (tblMemo maybe) is included in the forms underlying query and there is a relationship between the table you're entering data for and the tblMemo, then the field will "autopopulate" when a memo is selected... without code.