Importing Form Data

[ejf071189]

I have a form for filling out client information that has a command button that opens up a spouse information form for that client. The data for both of these forms go to the same table, which is the "clients" table.

Since many client's spouses are also clients, it would save alot of time to be able to import a client as a spouse.

As an example, if Jane Doe and John Doe are both clients, and I have all of their information on their respective client forms filled out, when I'm in their spouse forms, I want to be able to click a button that presents me with a list of clients that i can import, linking c_fname, c_lname, c_ssn, etc. with c_spouse_fname, c_spouse_lname, c_spouse_ssn, etc. Remember, all of these fields are in the "clients" table.

Is there a way this can be done?

Thanks.

--Evan

 

[pbaldy]

I can think of any number of ways to do this. If you had the selected client in a combo box with all the info, upon clicking a button:

Me.ControlName = Me.ComboName.Column(x)

where x is the desired column (which is zero based).

 

[ejf071189]

So this would be put under the button's events under "on click"?

When I did this, I got an error that "me" was not found as a macro, do I need to create it?

 

[boblarson]

When I did this, I got an error that "me" was not found as a macro, do I need to create it?

Then you are putting it the wrong place - you are putting it in the property and not the VBA window. See here for more about that:
http://www.btabdevelopment.com/main/QuickTutorials/Wheretoputcodeforevents/tabid/56/Default.aspx

 

[ejf071189]

Ah, ok, that worked, thank you.