Can you have a filtered recordset in a combo box?

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

I have 6 combo box on my main for that the user use to
filter the records.
I have the box's Row source set from the main table which
pulls all the records
and if a user pull a record that is not in the filter
recordset the get an error,
is it possible to set the recordset for the filter
records only?
Any help will be greatly appreciated.
 
Sounds to me as if your Combo Boxes have Row Source that is dependent on the
content of other Combo Boxes. If so, then as you change the value in a Combo
Box, in its AfterUpdate event you Requery dependent Combos, which, in their
RowSource refer to the Combo on which they depend.

I've never had a data structure sufficiently complex to require six
dependent Combo Boxes, but have done this (in real life) with three, and to
demonstrate sychronizing Combos, with four.

Larry Linson
Microsoft Access MVP
 
Back
Top