Populate form from table

[shaymomx5]

Good afternoon All,
I know there is a way to do what I need, but I am a bit rusty with my Access skills. Any help is greatly appreciated!

Here is what I would like to do as an end result...
When my users enter a name and company on my form, I would like for the address and contact information for that person to automatically fill in on the form. If they are not already in the contacts list, I would like for the record to be added. Any idea how I accomplish this?

So far I have the tblAccts (which would be the main information entered on the form), tblContacts (where the names, companies,and contact information is stored), and frmAcctOpen (the user's form for opening accounts).

I have tried a combo box, but didn't get what I was trying to do. I am using Access 2000. It has been about 6+ years since I have really messed around with access, so I am like a newbie and ask that you please speak basic language (idiot level if able :o) ) in your answers.

Thank you!

[maxamis4]

There are a couple ways to do it. The easiest method is using two subforms in one parent form, and then using the control source which resemebles a queries to specifiy which control filter by.

If you want to send me a copy of your database, and I can do it for you that might work out better. Please zip the file and send it to [e-mail].

Good afternoon All,
I know there is a way to do what I need, but I am a bit rusty with my Access skills. Any help is greatly appreciated!

Here is what I would like to do as an end result...
When my users enter a name and company on my form, I would like for the address and contact information for that person to automatically fill in on the form. If they are not already in the contacts list, I would like for the record to be added. Any idea how I accomplish this?

So far I have the tblAccts (which would be the main information entered on the form), tblContacts (where the names, companies,and contact information is stored), and frmAcctOpen (the user's form for opening accounts).

I have tried a combo box, but didn't get what I was trying to do. I am using Access 2000. It has been about 6+ years since I have really messed around with access, so I am like a newbie and ask that you please speak basic language (idiot level if able :o) ) in your answers.

Thank you!

[shaymomx5]

There are a couple ways to do it. The easiest method is using two subforms in one parent form, and then using the control source which resemebles a queries to specifiy which control filter by.

If you want to send me a copy of your database, and I can do it for you that might work out better. Please zip the file and send it to [e-mail].

Maxamis4,
I sent you the database, did you receive it?

[maxamis4]

Sorry it took me so long to reply. No I didn't get it. Did you send it as a zip file or as an mdb. Yahoo and most mail services block mdb content from their servers.

Maxamis4,
I sent you the database, did you receive it?

[shaymomx5]

Sorry it took me so long to reply. No I didn't get it. Did you send it as a zip file or as an mdb. Yahoo and most mail services block mdb content from their servers.

Maxamis4,
Now I am the sorry one for the delay. I had to send it as a mdb because I don't have the utilities at work to zip it, nor the authority to download a program to zip it. It is only 336kb because I deleted all the excess data and forms. I will try to send it to you again. It will be coming from [e-mail].

Thank you