Updating Field in Form
This seems so simple and yet I can't get it to work no matter what I try. Maybe someone can suggest something.
I have a form for data entry into a table. On this form there is a combo box used to select a project number from another table. The table contains project numbers and their names. I would like to display the name of the project in another control.
I have tried using DLookup() in the Control Source field of the control, but that didn't work.
I then added the DLookup() function to the after update event of the Project Number combo box and when the Project Number was changed it updated the Project Name box, but it didn't update it when moving from record to record.
I tried adding the DLookup() function to several other event routines, but it still didn't update it when changing records.
I then tried using a query with [Forms]![Enter Task].[Combo51] as the criteria (Combo51 is the Project Number combo box). The query produces the correct results when standing alone, but when I use the query as the data source #Name? apears in the Project Name box on the form.
I'm running out of things to try, so if anyone has any suggestions, I would appreciate it.