textBox refresh

[CoffeeGuru]

I am using a DLookup to default a value in my TextBox
This text box has an event attached to it that updates a table when a different value is entered.

I am having difficulty in getting the default value to reappear when I change my critera.

For instance Manufacturer is Ford
Colour is default Black
I Change the colour to red

now I change Manufacturer to Audi
I need Default colour to go back to Black

The Lookup Table says Black its just that the default value only seems to run once, first time in and never again unless i exit the database and reopen it.

Any ideas

Martin

I have tried adding

Form.Repaint
form.Refresh
Form.Requery
to my afterupdate query

 

[CoffeeGuru]

Im assuming you mean in the [Event Procedure]
but no that made no difference

and I cant see an after update in the forms properties...

 

[CoffeeGuru]

See if this helps.

lol yes it did help, but it didnt work anyway
I added me.requery in an [Event procedure] to After Update

Martin

 

[CoffeeGuru]

So which event did you settle on?

I used forms afterupdate