>I followed the instructions on your site and started over. The key works fine as long as I am in a single user environment.
>In my form I have a textbox called text1. It's control Source is set to the primary key of the table. That field calls the
getkey function.
>When I try to do multiple sessions I get a uniqueness of key error.
>Question:
>What do i have to do in order to make this work if more than one person tries to add a record at a time?
I'm not sure what you did exactly. The code works in a multiuser environment. Can you send me the exact code you are using?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer