Open a new form based on current form and append new record query

[hollis via AccessMonster.com]

I am creating a questionaire for Human Resources.

I have created a form from the [Associates] table for the user to select
their info, update or add if needed, then click a command button named
CreateSession. This command button runs an append query that INSERTS the
EmpID field INTO the [Session] table thereby creating a new Session record.

I would like in this Assoicate Form to add a command button based on a macro
that will run the above append query and then have a new form open based on
this new Session record. My first thought was to have the Associate form
close and load the new form based on the newest Session record. The database
will be deployed on our intranet so it is concievable that the newest Session
record would not actually be the desired record.

 

[hollis via AccessMonster.com]

further thinking...
If I create a select query based on the Session table, using criteria to pull
only matching the current Associate form (the EmpID field from my earlier
post) plus criteria to select the more resent date.....