Label as button doesn't change focus

[krausr79]

I'm using a label as a button so it looks nicer, but if I press it without officially exiting the last text field I was in, then that text field doesn't update, so the vba believes it's blank or whatever it was.

I could manually setfocus to a couple different fields or have a teeny field thats hard to see to set focus to, but these both seem roundabout. Is there an elegant way to deal with this problem?

 

[MarlaC]

The (usually) easy way to deal with this is by adding a statement to your label code of

Me.Dirty = False

 

[krausr79]

No dice. My main form is unbound to any data and I get "You entered an expression that has an invalid reference to the property Dirty". The textbox itself is also unbound. I just check if the textbox is not blank and if so I use sql to update a field to the value in the box.