how to trigger access to set autonumber for new record?

[dyy]

Hi,



I have a 'Add' button to add a new record to a form. But access won't assign the PrimKey (autonumber) until some 'entries' in the form are 'modified'. But I like to open a 'subform' through a button which is linked to the 'parent form' through this ID. Is there a way to set the form 'dirty' and trigger it to refresh and set the PrimKey the minute I add a new record so I can pass it to the 'subform' by using TempVar?

Thanks,

DY

[ajetrumpet]

don't really understand this. to my knowledge though, records are not officially "added" when there's an autonum PK until the record is actually dirtied in another way by the user.

I'm "almost" sure about that.

[dyy]

Adam,

I don't disagree with you.

My problem is 'how' can I 'force' access to treat the record as 'dirty' and generate the primary key? I like to do it in a macro if possible.

To rephrase it, how I can add a record 'automatically'? I don't want to force a save though.

Can I use 'Me.dirty' somewhere and use 'refresh' or 'refresh record' to trigger it?

Thanks,

AYY

[kennejd]

I believe if you add a me.refresh line to the button that opens your 'subform', it will save the record (if the mandatory fields are filled in) and create the primary key.

[ajetrumpet]

To rephrase it, how I can add a record 'automatically'?

dump the autonumber and generate a unique number with a DLAST() or other domain function behind the ONCURRENT() event or something like that. hence, your own autonumber created via code.