hi,
i want to filter fields in a table on my form but the problem is that the field (Included/Excluded) in the table is in the format of YES/NO. i dont mind if the filter on my form is in the form of a list box, option button or a check box but i want to be able to search for all records, included or excluded.
the way that i have tried to do it is by creating the subform in my form to show the data. this is liked back to the table...