Form Help

[jjm0926@gmail.com]

Hello everyone. I am brand new to Access and am in need of some help.
I have a database with three main tables--customers, project, and then
a joined table called project_custome rs. In the customers table there
are these fields--customer_id, firstname, lastname, address, city,
state, zip, sex, age. The projects table has project_id,
project_number, project_name. The joined table is joined with the
primary key from both tables. I would like to create a form where a
user can select different things and click on a button and it would
pull all the records based on the selection that they made for
example--if I selected female, age 30, city of chicago--when I click on
a button it would just give me all women at age30 with city of chicago.
Can anyone help me with this. Once again I'm new to Access so I do
apologize you will have to explain in lamens term or step by step.
Thanks.

[Tom van Stiphout]

Re: Form Help

On 31 Jul 2006 11:46:25 -0700, jjm0926@gmail.c om wrote:

This is one area where Access (and you, as the smart developer taking
advantage of it :-)) can really shine.
If you have a parent/child form with a parent form showing the
customers, and a subform showing the selected projects for that
customer, all you need is the built-in Query By Form to do what you
want.

-Tom.

>Hello everyone. I am brand new to Access and am in need of some help.
>I have a database with three main tables--customers, project, and then
>a joined table called project_custome rs. In the customers table there
>are these fields--customer_id, firstname, lastname, address, city,
>state, zip, sex, age. The projects table has project_id,
>project_number , project_name. The joined table is joined with the
>primary key from both tables. I would like to create a form where a
>user can select different things and click on a button and it would
>pull all the records based on the selection that they made for
>example--if I selected female, age 30, city of chicago--when I click on
>a button it would just give me all women at age30 with city of chicago.
Can anyone help me with this. Once again I'm new to Access so I do
>apologize you will have to explain in lamens term or step by step.
>Thanks.

[JJM0926]

Re: Form Help

I think I may have already done that. I used the Autoform button at
the top of the toolbar. When I click off design view it gives me all
the records with all the fields. Now how do I set up a separate form
where a person has to make the different selections and just only those
records show? Thanks.

Tom van Stiphout wrote:

On 31 Jul 2006 11:46:25 -0700, jjm0926@gmail.c om wrote:
>
This is one area where Access (and you, as the smart developer taking
advantage of it :-)) can really shine.
If you have a parent/child form with a parent form showing the
customers, and a subform showing the selected projects for that
customer, all you need is the built-in Query By Form to do what you
want.
>
-Tom.
>
>

Hello everyone. I am brand new to Access and am in need of some help.
I have a database with three main tables--customers, project, and then
a joined table called project_custome rs. In the customers table there
are these fields--customer_id, firstname, lastname, address, city,
state, zip, sex, age. The projects table has project_id,
project_number, project_name. The joined table is joined with the
primary key from both tables. I would like to create a form where a
user can select different things and click on a button and it would
pull all the records based on the selection that they made for
example--if I selected female, age 30, city of chicago--when I click on
a button it would just give me all women at age30 with city of chicago.
Can anyone help me with this. Once again I'm new to Access so I do
apologize you will have to explain in lamens term or step by step.
Thanks.