Filter suggestions in form

[Lars Brownies]

I used to have an unnormalized main table (Person) with, amongst others,
boolean fields Category 1, Category 2, Category 3. When used in a form I
could easily filter one or more categories by using the selection filter
option. I've now normalized the table by adding a 1xM Person-Category table.
The field Category can have value A, B, or C. So far, so good.

On the form I still want the user to be able to switch easily (by one
click?) between the main records of one or more categories. How would I go
about this? Should I use a listbox and let the user pick one or more
categories and then set the records source of the form to a corresponding
query? Or are there better ways?

Thanks,

Lars

 

[Jeanette Cunningham]

An easeir way would be to set the form's filter to the chosen category or
categories.
For a sample database that shows this for combo boxes, have a look at

http://allenbrowne.com/ser-62.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Lars Brownies]

I think is another situation. In Allen's example the client can have only
one 'level', so that's easy to filter. In my case there can be more
categories for one person. Or am I missing something?

Lars

 

[Jeanette Cunningham]

You wrote "On the form I still want the user to be able to switch easily (by
one
click?) between the main records of one or more categories"

To do the above, you would have a combo box with the category names as its
row source.
When user selects a category, the search form shows all names for that
category.
Is this what you want?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

Reading your post about the query.
You can use the search form to locate the record to edit.
You can put a double click event or a button so that user can open a
separate form where details can be edited and make this form open to the
person selected on the search form.
This gets around the problem of the record source for the search form not
being able to be edited.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia