Dlookup in form doesn't work when I validate a defaultvalue from previous record

[daniel.preda]

I am using in the form the folowing code:

Private Sub Store_AfterUpdate()
Me![Store].DefaultValue = Me![Store].Value
Me![Manager] = DLookup("Manager", "Actual Managers", "Store = " & Me![Store])
End Sub

I need the number of the store to be automaticly updated after the last record i entered, then the manager name looked up after the store number.

This works like a charm only when i type the store number... when i use the last record store number (it is completed automaticly as I wanted, I just hit Enter), the dlookup doesn't work anymore...

[RuralGuy]

You do not get an AfterUpdate event if nothing has been changed. You may want to put your code in the OnExit event of the control instead.

[daniel.preda]

you're right... thanks... i'm new in access... but i'm beginning to figure it out..