Unanswered: populate from text fields from list box
Using MS Access 2007. I have a form with some text fields and a list box. The list box has 2 fields. I would like to allow the user to select a line in the list box and take the 2 values in the highlighted line and update 2 matching fields on the form. What is the best approach?
Form fields are;
TaskId and TaskName
the list box fields are Task_ID and TaskName.