Form sourced to table with autonumber as PK opening to new record

[Mattbro]

Hello All,


I have been 'upgraded' to Access 2010. In my Db I have a form "FrmSent" bound to a table "TblSent". The table has an autonumber as the PK called "ID". I open the form on the click of a button from another form, and at a new record using

 DoCmd.GoToRecord acDataForm, "FrmSent", acNewRec

in the 'On Load' property of FrmSent.
I need the "ID" box to automatically populate with the new record ID number, but will it? No, it will not! Thus when I close the form, I get the usual 'cannot contain a null value message'. I have messed around with the form, set 'Data Entry' pro[erty to yes, deleted it, rebuilt it....can't get it to work!
Can anyone throw any light as to what I am doing wrong?
Many thanks,
Mattbro

[RuralGuy]

Are you saying that an AutoNumber field on your form will not populate when you change other fields on a new record and then try and save it?

[Mattbro]

Right you are. Thats exactly whats happening! Form has table as source, opens to new record....ID stays empty! Flummoxed....

[RuralGuy]

It will stay empty until you change another field which will Dirty the record. But you knew that right?

[Mattbro]

Thats the problem. I can fill in all the other textboxes in the form-each obviously linked to a field in the table, the ID box still does not populate. I try to close the form and I get the null value warning. Don't get it. Never happened before. The autonumber just doesn't appear or seem to generate...... Currently, I don't have a 'save' command in the code. I tried putting one it, but it still gave me the same problem.
Would it be to do with me coding the form to open at a new record? Is there some property in Access 2010 that I don't know about when linking forms to tables? Should I have the data entry property on the form ticked?

[RuralGuy]

Try a Compact and Repair first. If that does not resolve the issue then try *importing* your db into a fresh new db and see if the issue follows. http://www.btabdevelopment.com/ts/impnew

[Mattbro]

Hmm. Exported the data out as excel, deleted the db, started again from scratch, and has worked. Not sure what the issue was, but that's working now. Thanks.
M

[RuralGuy]

Thanks for sharing your success and solution.