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!

On Fri, 14 Mar 2008 09:31:03 -0700, BMoroneso
<BMoroneso@discussions.microsoft.com> wrote:

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

             John W. Vinson [MVP]

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.
-- 
Dave Hargis, Microsoft Access MVP


"BMoroneso" wrote:

> 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!