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.

Thanks,

Charlie

Did you put the DLookup() on the On Current Event of the Form? The combo should also be synched on the On Current Event.

Normally I would do this with a combo look up (made with the wizard) on the On Current Event:

Combo0 = ProductID

As an example.

If you synch the combo this way, then run the DLookup() right after, that might work.

mmcdonal

Look it up at: http://wrox.books24x7.com

I knew there had to be an event I was missing! That did the trick. Thanks for your help.


Charlie