Art,

I'm using a series of checks within the code to prevent multiple
submissions.  Basically, I set a boolean flag in the database upon opening
the form that prevents another user from opening the form.  With this check
in place a second copy of the form can never be opened.  The rules on open
check the flag, then automatically display a message to the user and closes
the form if the boolean flag is set.  The custom submit button in the form
then clears that boolean flag so the form can be accessed by someone else.  
There is no concern over multiple simultaneous submissions there will never
be 2 copies of the form open.  

All I need is an example of the command or series of commands that will
return the last record.  From there I can extract the unique ID.

I know there's a SQL command that returns the last row/record on a query but
don't know if there's a similar command for IP to do the same thing.

Michael

As it happens I answered my own question.  

I created the query in Access using
SELECT TOP 1 [Tablename].*
FROM [Tablename]
ORDER BY UNIQUEID DESC
WITH OWNERACCESS OPTION;

This query sorts the autonumbered unique ID in descending order putting the
last entry at the top, then returns the top row.

Then I created a secondary data connection to the query, and then added a
rule behind the button to query the secondary data connection.

Presto, last record returned when using an autonumbering scheme.

Enjoy gang...