R
rg32
I have a form with a combo box and a subform (in continuous view) to display
records based on the (ID) selection in the combo box. Despite the find
record code in the combo box, the subform was still displaying all the
records, just with the selected record first. I assume this was due to the
continuous view, but there are some ID's that have several records and I
wanted them all to display- didn't know how else to do that except with
continuous view.
Anyway, I've added a filter to get only the records for the selected ID,
which works, but I'm not sure how or where I should turn it off so the user
can make a new selection. Right now it works for the first ID selected, but
If the user tries to select a different ID, I get no record message. There
are records for all ID's listed in the combo box. I think I need to find a
way to turn the filter off, then turn it back on when they make a new
selection. Anyone have any ideas on how to do something like this? I've
never used filters before so I'm just kind of guessing at this right now.
records based on the (ID) selection in the combo box. Despite the find
record code in the combo box, the subform was still displaying all the
records, just with the selected record first. I assume this was due to the
continuous view, but there are some ID's that have several records and I
wanted them all to display- didn't know how else to do that except with
continuous view.
Anyway, I've added a filter to get only the records for the selected ID,
which works, but I'm not sure how or where I should turn it off so the user
can make a new selection. Right now it works for the first ID selected, but
If the user tries to select a different ID, I get no record message. There
are records for all ID's listed in the combo box. I think I need to find a
way to turn the filter off, then turn it back on when they make a new
selection. Anyone have any ideas on how to do something like this? I've
never used filters before so I'm just kind of guessing at this right now.