auto fill off queries

webharvest

New member
Local time
Today, 07:53
Joined
Sep 12, 2006
Messages
6
I set up an Access database to track visiting families. Each person in a family is inserted as a seperate row in my table. The table has the following columns: Head of household, last name, first name, phone, email, address and etc.

I set up a quiery with a pull down menu in my form so when I enter a new entry I can select a head of the houshold to assign each person to. So if we have a family visit that has a husband, wife and a child. There are three entries each having a head of the household as the same. When I use the query to select the head of the household I would like the information that is the same as the "head of the household" (address and phone #) to be automacially filled in from the husband initial entry.

How can I do this?

Thanks
 
Last edited:

Users who are viewing this thread

Back
Top Bottom