Refresh Requery Recalc ?

Hi,

I am a newbie at doing VBA in Access and have hit a wall that is proving to confuse me.

I have 3 combo boxes (CboActivity, CboInterCo and CboNominalAccount) that are then concatenated into a text box (TxtNominal) ... all works fine.

I have a second textbox (TxtLedger2) that is a Dlookup of the value in TxtNominal that will not refresh when any of the Combo boxes and TxtNominal changes. If I go to design and back to form view then the box does refresh with the result of the new dlookup so I know that is OK.

I have tried Me.Requery, Me.TxtLedger2.Requery, Me.Recalc and on the On Change, On Dirty and After Update events on each of the combo's, the TxtNominal and the form.

I have tried to look it up on the net and following all of the examples, I cannot find where I am going wrong.

Thanks for whatever help you can offer.

I have managed to fix it now. For some reason it was not working on the On Dirty, On Change or After Update events but it does work on the On Click event of the Combo Boxes.