Save a Record Without Moving To a New One? 1

[Hakala]

Good morning, Tek-Tippers!

I have a multi-user Access 2002 database. One of the data entry forms is locking the records for other users, even though all the settings I can find to check are right (No Locks, etc).

I'd like to add a Save Record button for that form, which would save the record and STAY on the record saved. Everything I've tried bounces to a new record after saving.

Help? I'm hoping if the user stays on the record while she sort through her work for more data to enter, rather than being on a new record, she won't be locking other users up anymore. (Other users receive an "Unable to update" message.)

Thank you!




Michelle Hakala

http://www.winebird.com/

 

[Remou]

Have you tried
DoCmd.RunCommand accmdSaveRecord

 

[Hakala]

Thanks, Remou!

I have, and it bounces to a new record. I think this database is possessed; it shouldn't be locking the records, either. :-(


Michelle Hakala

http://www.winebird.com/

 

[Remou]

Have a look to see if there is any code associated with the form that moves to a new record. Is the form set to DataEntry?

 

[Hakala]

I'd been through the code before (validation, adding a user name from login, some other stuff) and thought I didn't see anything, but there is. Once I REMmed the line out, it worked. Now I have to go find out whether I've broken anything by removing that line.

Thank you, Remou! Have a star.


Michelle Hakala

http://www.winebird.com/

 

[missinglinq]

"Bouncing to a new record" makes me think of the form's Cycle property being set to the default, which is All Records. Check and if this is true try changing to Current Record.

Linq

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!