Multiple forms

[Whitney]

I need help using three forms to do the following:

First form will be used by an agent to enter their own id and today's date,
click ok to go to the next form (agent id and name retrieved from table
tbl_SSR). This will only be done once while they have the dbase open, the
form should close or not be visable after this step.

Second form will be used to enter the caller's agent id, click ok (caller's
agent id and name are retreived from table tbl_Agent). This will need to
reappear after the third form.

Third form will be used to enter the details of the call. The first and
second form data should autopopulate at the top of this form.
Ex:
SSR Name
Agent ID - Agent Name
Date

The autopopulated data and the additional data should be stored on
tbl_tracker.

After the third form is completed, I need the second form to reappear for
the next call.

I have basic Access and VisualBasic knowledge.

 

[John W. Vinson]

I need help using three forms to do the following:

First form will be used by an agent to enter their own id and today's date,
click ok to go to the next form (agent id and name retrieved from table
tbl_SSR). This will only be done once while they have the dbase open, the
form should close or not be visable after this step.

Second form will be used to enter the caller's agent id, click ok (caller's
agent id and name are retreived from table tbl_Agent). This will need to
reappear after the third form.

Third form will be used to enter the details of the call. The first and
second form data should autopopulate at the top of this form.
Ex:
SSR Name
Agent ID - Agent Name
Date

The autopopulated data and the additional data should be stored on
tbl_tracker.

After the third form is completed, I need the second form to reappear for
the next call.

I have basic Access and VisualBasic knowledge.

The simplest way to do this would be to make the third form a Subform of the
second, and do away with the first form altogether - unless I don't understand
who these "agents" are. I'd expect the user's ID to be something which could
be a default value in (their own) copy of the frontend, or be derivable from
their Windows logon.

What are the tables? How are they related? What are these agents?