Recent content by itguru81

I figured out what the problem was... The "increment" function which was inputting the primary key on th new form, was being sent from the previous form, rather than the new form under "On Load" thus the value was not loading during the load event and could not save.

Thats exactly the problem, I tried that exact code and it does not save it. It has nothing to do with shifting focus. Taking all other functions out On Load event, and only using docmd.RunCommand acCmdSaveRecord does exactly NOTHING. Try it yourself, create a form that opens from another...

I have been trying to figure this out all day. Here is my situation. I have a Form that loads giving users several options. They select one and that opens the data entry form which has several fields such as formid, current date, user name, etc. All these fields are autopopulated... but they...