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?
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide
LeRoy Jackson