Dlookup update problem on current record

[Cosette]

Hi all,

I have a form that writes to a table. Depending on the value I select in a combo box, a few dlookup values get generated in other controls. Unfortunately, the values are displayed only after the record is saved by going to a new record and going back to the previous record. Unfortunately none of the values are stored in the table. I need the dlookup values to be stored as I go along. How do I fix this problem?

Thanks,

Cosette who feels hopeless

 

[ssatech]

Have you tried the Requery Method to refresh your form?
Do you have the DLookup in the control source of the field?

 

[Cosette]

Thank you, Requerying on update was the key.