Filtering this bound form?? how??


R

Ron

Hello, I have a bound form that is bound to a table called STUDENTS. On
this form, frmStudentFilter I have:
STUDENTNAME
STUDENTCLASS: recorded as 1,2,3,4
STUDENTGENDER
STUDENTSTATE

What I want to do is this, put a button on the form thzat says
filter....when this is prerssed a popup dialog box opens with a optiongroup
and radiobuttons that say ALL, CLASS, GENDER, STATE

Besides the CLASS, GENDER, AND STATE, I want to put combo boxes so for
example if they select the radiobutton GENDER THEY CAN THEN CHOOSE either
Male or female from the list in the combobox. When they do this and select
a button called OK, my frmStudentFilter form would then show students
filtered for that selection.

How would I accomplish something like this?
 
Ad

Advertisements

Ad

Advertisements

A

Albert D. Kallal

This feature is built into ms-access.

While in the form, Just go:

Records->Filter->Filter by form

You will then be able to enter any values into those fields. this feature
is commonly know as

filter by form
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top