423,818 Members | 2,250 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,818 IT Pros & Developers. It's quick & easy.

Form Help

P: n/a
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_customers. 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.

Jul 31 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 31 Jul 2006 11:46:25 -0700, jj*****@gmail.com 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_customers. 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.
Aug 1 '06 #2

P: n/a
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, jj*****@gmail.com 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_customers. 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.
Aug 1 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.