Save current record in form...

[twinmill]

I have a form with recordsource based on a query to a table. At startup, I turn off all menus and toolbars except the default shortcut menus.

In the form, I created a button with an On Click event to save the current record:

DoCmd.RunCommand acCmdSaveRecord

When I run it, I get the following error:

You can't reference a property or method for a control unless the control has the focus.

Why do I get this error, and is there a better way to save the current record?

 

[twinmill]

Found why the error was coming up. It had nothing to do with the DoCmd.RunCommand acCmdSaveRecord.

It was caused by a bug in an If statement where one of my conditions used "me!txtField.Text" and I changed the "Text" to "Value", and now everything works fine.