View Full Version : Recordset


skwilliams
03-07-2002, 08:44 AM
I have a table1 and a form1 which refers to it. I also have a table2and a form2 which refers to it.

I need to be able to input data into form1 and store it, such as:

Name SSNo Phone
Jane Doe 123-45-6789 812-555-5555
John Smith 987-65-4321 800-555-5555

In table2 I need to be able to select "John Smith" for example from it's name field as a drop down list and have the SSNo field autofilled with 987-65-4321 and Phone autofilled with 800-555-5555

I don't want the name field to be a dropdown list in table1 because I'll need to input that information.

I need both tables because the same information will be used in table2 each month along with additional information not in table1, so it would be easier to just choose a name from a dropdown list than enter the name, SSNo, and phone. And this gives my users the ability to add information to table1 via form1.

I'm using Access 2000.

Thanks.

chrismcbride
03-07-2002, 09:55 AM
Sounds to me like you need to bind both forms to the same table. Form One shows some information from Table One and Form Two shows other or more complete information.
Relating to the use of a Drop Down list or Combo Box, you can use an unbound CB which is populated with a SQL statement and have navigational code behind it's AfterUpdate Event (Wizards will show you how this is done). You can even hide the CB when you are on a new record and replace it with a bound text box. In this way you can do data entry.
HTH
Chris