Click away from textbox or combobox when executing Save command

[kagoodwin13]

I've done a lot of Google searching, and this problem seems to be common, but too vaguely worded to find a solution.



I have an unbound form that has several fields, and a save button that updates the desired table and fields.

The problem I am running into is that when the save button is clicked, the last edited textbox or combobox is still "being edited," and is in that phase until I click somewhere else on the form. After updating AND clicking, the new value is stored in the textbox/combobox.

Is there a way to programmatically click away to somewhere else, which would in effect save the value of the last edited field?

Thanks!

[pbaldy]

Really? I haven't seen that behavior. Clicking on the button should "save" the textbox, since focus has left it. I just tested and the after update event of a textbox fired when I clicked on a button, then the button click code. Can you post a db that exhibits this problem?

[ItsMe]

...the last edited textbox or combobox is still "being edited,"...

When a control loses focus it will already be updated. In other words, the AfterUpdate event has already committed the Text property to the Value property. If a textbox control loses focuses after the text propert has changed, the Form's Dirty property will = True.
KeyDown > BeforeUpdate > AfterUpdate > Exit > LostFocus

https://support.office.com/en-in/art...86553682f9#bm4

[kagoodwin13]

I was able to solve it, but it doesn't really make much sense to me. Upon pressing the save image, I changed focus to another combobox in the form that can't be edited.

The purpose was to save the value in txProjectNotes. The problem was that after being edited, txProjectNotes would not lose focus, the focus was stuck on the textbox, even if the save image was clicked. That meant as a result, that if a new value was typed into txProjectNotes, it wasn't stored before the save image was clicked.

It may have something to do with the fact that the textbox Enter Key Behavior was changed to New Line In Field. It may also be that images behave differently than command buttons with concern to focus.

I tried to change focus to another textbox that is hidden, but Access wouldn't allow that. I guess that makes sense - can't focus on a hidden field.

Working code:

'Click away from editable fields to save values
Me.cmCustomerName.SetFocus
'Run update command
strUpdate = "UPDATE tProject SET tProject.ProjectNotes = '" & Me.[txProjectNotes].value & "' WHERE tProject.ProjectName = '" & Me.[cmProjectName].value & "'"
DoCmd.RunSQL strUpdate

[ItsMe]

...Enter Key Behavior was changed to New Line In Field...

That could be something. Adding data validation and using variables might help to pinpoint the cause.

[pbaldy]

You said save "button" in the first post, save "image" in the second. If you're using an image for a button, it could be that an image can't have focus and thus focus doesn't leave the textbox, so I think this is your issue:

It may also be that images behave differently than command buttons with concern to focus.