Create Data Entry "Wizard"

[BMoroneso]

Hi everyone,
I'm trying to create a data entry "wizard" for a database. Basic premise -
a company has clients that they need to be able to track various aspects of
information about. All information might not be available at the time of
entry.

I'd like to have an AddClient form (data entry mode) with buttons for Add
Address (ClientAddress form), Add Phones (ClientPhones form), and Add Emails
(ClientEmails form).

How can I pass the ClientID value created on the AddClient form to the
ClientAddress (and other) forms?

Thanks in Advance!

 

[John W. Vinson]

Hi everyone,
I'm trying to create a data entry "wizard" for a database. Basic premise -
a company has clients that they need to be able to track various aspects of
information about. All information might not be available at the time of
entry.

I'd like to have an AddClient form (data entry mode) with buttons for Add
Address (ClientAddress form), Add Phones (ClientPhones form), and Add Emails
(ClientEmails form).

How can I pass the ClientID value created on the AddClient form to the
ClientAddress (and other) forms?

Thanks in Advance!

It's simpler than that... a lot simpler.

How about no buttons, no code?

Just use a Form based on your Client table, with three Subforms for the other
data. If you use the ClientID as the master/child link field the user will be
able to simply type the phone or email or address directly into the subform;
it will be saved to the table automatically.

 

[Klatuu]

There are a couple of ways to to this. If all the forms use the same table
and the Cleint's record is already in the database, you can use the Where
argument of the OpenForm method to present the client's record.

If you will be creating a new record, then you could use the OpenArgs
argument of the OpenForm method to send the required data to the form being
opened. Then in the form being opened, you can use the form's OpenArgs
property to create a new record.