H
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.
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.