Auto Populate Description Field by Data Entered into Code Field

[cshipley83]

Hi. Needing help with a form field. I have a form made up of two tables (Donors and Deposits), Deposits is a subform. In the Deposits I have two fields (Code and Description) that need to populate from a third table (Codes). I want to enter in a numerical code (example 5710) and I want the description to auto populate. How do I go about doing that?

 

[Minty]

Use a combo box. Set the row source to a query that links your tables together - you can build this in the combo box properties.