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

[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...