R
Reader1
Hello
I would like to add an option on a form that lets the user filter the
records that are displayed.
At the moment I am using three different forms, one for each filter sort and
another to show all unfiltered records.
For example .......
I have a table called tblData with fields, Phase, Unit, Descriptor
The associated form is called frmData which displays all the records in each
three fields from the table.
I would like a way of displaying only those records that match the criteria
specified on the filter.
I only want to filter on the field called 'Phase' which has entries of
either 'A' , 'B' or 'C'
Maybe an option group or a combo box ?
So on the form if you click the option that says 'A' you would only see
records on the form that have 'A' in the Phase field
The same for 'B' and 'C' and another to show all records.
I'm new at this so make it simple please.
Thank you
I would like to add an option on a form that lets the user filter the
records that are displayed.
At the moment I am using three different forms, one for each filter sort and
another to show all unfiltered records.
For example .......
I have a table called tblData with fields, Phase, Unit, Descriptor
The associated form is called frmData which displays all the records in each
three fields from the table.
I would like a way of displaying only those records that match the criteria
specified on the filter.
I only want to filter on the field called 'Phase' which has entries of
either 'A' , 'B' or 'C'
Maybe an option group or a combo box ?
So on the form if you click the option that says 'A' you would only see
records on the form that have 'A' in the Phase field
The same for 'B' and 'C' and another to show all records.
I'm new at this so make it simple please.
Thank you