Form question

C

cdavis82

I have a form linked to one table that has several different pieces of
information. I have a Yes/No question that asks if the employee is active.
Any way to force the form to only show employees that are active? I can
still change the question through the table itself if needed.

Casey
 
D

Douglas J. Steele

Create a query that only returns active employees. Base the form on the
query, not the table.
 
M

mnature

If you go through a query to create your table, you can use the query to
filter out only active employees.
 
C

cdavis82

I am just learning Access. Right now my form is getting all of its info from
a table. How do I get it to get all of its info from the query?
 
M

mnature

Use the query wizard, choose the table you are using for your form, and
select all of the fields. Use Design view to set criteria in the query for
what you want to show on your form.

Now go to your form, go into design view, and open the properties window for
the form. Under the Data tab you can choose the Record Source. It should be
set to your table right now. Click on it, and all of your tables and queries
should show as a list. Choose the query that you just created. The fields
should be the same (since you used all of the fields for the query that were
in the table), so your form should look and act the same, except for the
filter which you applied to the query.
 
Top