How can I get the Primary Key to show up in an e-mail?

[FargoBison]

I created a Help Desk database that once I have the form completed I click on
a macro that takes the information I have selected and places it into an e-
mail using outlook and will be e-mailed to the tech to take care of the pc
issue. I have the tables stored on the server and they are linked to Access
2003.

All the information transfers over except for the Ticket ID (which is the
primary key) field. It doesn't enter that into the e-mail since it really has
not been created because the table has not been updated. I had the table set
to Auto-Number and on the server I had it to increment by one and the seed
was set to start at 100.

Could anyone please give me any ideas how I can get that to update before I
create teh e-mail ticket?

Thanks

 

[John W. Vinson]

Could anyone please give me any ideas how I can get that to update before I
create teh e-mail ticket?

Put a line in the code

If Me.Dirty = False Then Me.Dirty = True

This will force a write of the record to disk, and increment the autonumber.

John W. Vinson [MVP]

 

[FargoBison via AccessMonster.com]

Put a line in the code

If Me.Dirty = False Then Me.Dirty = True

This will force a write of the record to disk, and increment the autonumber.

John W. Vinson [MVP]

Thanks for the help! I was trying to make it harder than it actually was