Problem with Saving a record with RunCommand

[slou]

After converting a 97 database to 2000, I have had problems in one form with saving a record to a table. Basically, a new record is created by a user and some basic information is saved to one table initially. Next, the new record is added to another table with one of the columns being the unique ID from the other table. Before the record is added to this next table and after the "DoCmd.RunCommand acCmdSaveRecord" command, the value of the unique ID is changed to the previous record instead of the new record we just saved.

 

[Karl K]

I had problems with save, too. Try this code:
DoCmd.DoMenuItem AcToolBar, AcFile AcSaveRecord

that always works. If you have a security system that does not allow all users full priveledges, you will definitately run into problems with DoCmd.Save, because that saves the form as well, and they may not be allowed to do that.

Anyway, try that.

 

[slou]

That function is no longer valid in 2000. It was replaced with the RunCommand.

I have tried just about everything.