Clear up Value on next record

[bl0u2011]

Hi everyone

I have a part of the form with the following fields

Title
Name
Address1
Address2
Area
...

Address2(street) field is a drop downbox, once selected the area text field will be automatically shown
what I got in AfterUpdate event on Street is as below
Me.txtArea = [cboAddress2].[Column](2)

the problem with this is, even when I move to another record the Area field doesn't clear up which is still using the old Area info that has been selected before,

I belive I have to have some Clear Up function on somewhere, not sure exactly where and what Code will clear up the value,

Can anyone help please!!

Thanks in advance
Si

 

[RuralGuy]

Try using the Current event to do some housekeeping. It occurs just as you enter a new record.