E
Eric Heinold
I have a form that has some filtering options in the header. The filters
include a couple of option groups, and some combo boxes. This form works
great in Access 2003 and earlier.
However, in Access 2007, if the filters are set to return no records, the
option group values appear to change to null (I get the null value in all
the options of the option group), and a text box that is also unbound on the
form gets set to null as well. However, if I change one of the filter
(click on an option in one of the option groups) so that the filter would
include the records, all my unbound values return.
All the filters are unbound fields, so they should not be affected (and they
are not in Access 2003) by whether there are records returned by the form.
Is there a setting in the form that I can change to make this work correctly
for Access 2007?
Thanks,
Eric Heinold
include a couple of option groups, and some combo boxes. This form works
great in Access 2003 and earlier.
However, in Access 2007, if the filters are set to return no records, the
option group values appear to change to null (I get the null value in all
the options of the option group), and a text box that is also unbound on the
form gets set to null as well. However, if I change one of the filter
(click on an option in one of the option groups) so that the filter would
include the records, all my unbound values return.
All the filters are unbound fields, so they should not be affected (and they
are not in Access 2003) by whether there are records returned by the form.
Is there a setting in the form that I can change to make this work correctly
for Access 2007?
Thanks,
Eric Heinold