Add Record Not Putting In Data

[no1biscuit]

Ok I have searched the forum and not finding my question(could be what I am searching for, but anyway).

I am doing

DoCmd.GoToRecord , , acNewRec
and then a select max(id) query to pull the autonumber (which I don't like but it works, kinda)

Then I run an insert sql statment to populate my subform becuase if not it is blank for sum reason. (I don't care for this either but it works)

It creates the blank record and when I type data in a couple of fields it doesn't put the data in to the table until I tab all the way through the record. Which the user is not going to do before changing forms and/or running my copy command.

Also since the data is not there (yet) my copy does not work right. I have a button on the form that copies the current record so before I copy it I need to save all of the data in the current record. How is this accomplished.

I am sorry if this is rambling but I am just frustrated.

Thanks in Advance
Thom

 

[Remou]

You can use:

DoCmd.RunCommand acCmdSaveRecord