K
klufkee
I have a form that is based on a query. There are 7 fields in the query
and they are all represented on the form. Six of those are combo boxes.
The form returns a total of 5742 records. I would like to filter those
records based on what is chosen from the combo boxes on the form. What
I am missing though is a way to limit the choices in the combo boxes
depending on what has been selected already in another combo box. As it
stands, I can select a value from one box, knowing that there are only
130 records that contain that particular value, but the other boxes
still list all available choices as if I had selected nothing. I'm not
sure if this will be easier to do using the 'Filter by Form' function
or not. I'm a total newbie to Access 2003 and I'm completely lost right
now.
Can anyone help me?
Bill K.
and they are all represented on the form. Six of those are combo boxes.
The form returns a total of 5742 records. I would like to filter those
records based on what is chosen from the combo boxes on the form. What
I am missing though is a way to limit the choices in the combo boxes
depending on what has been selected already in another combo box. As it
stands, I can select a value from one box, knowing that there are only
130 records that contain that particular value, but the other boxes
still list all available choices as if I had selected nothing. I'm not
sure if this will be easier to do using the 'Filter by Form' function
or not. I'm a total newbie to Access 2003 and I'm completely lost right
now.
Can anyone help me?
Bill K.