G
Guest
With ACCESS 2000 and ACCESS XP I could use the following code to dynamically
change the content of a subform, i.e. depending on what type of filter the
user had chosen in a combo box, I could feed the subform with different
content:
1 With Me.Controls("sfACT_SetFilters_Flt" & iFlt).Report
2 .RecordSource = szSQL
3 .Refresh
4 End With
Actually I don't know, what the report property in a form/subform stands for
(the help file mentions that this property exists, but not, what it's good
for, and why I can't access the RecordSource property directly) but it worked
reliably over years
In ACCESS 2003 I get the runtime error 2467 (the expression you entered
refers to an object that is closed or doen't exist). What's going wrong
there? What is so different in ACCESS 2003?
change the content of a subform, i.e. depending on what type of filter the
user had chosen in a combo box, I could feed the subform with different
content:
1 With Me.Controls("sfACT_SetFilters_Flt" & iFlt).Report
2 .RecordSource = szSQL
3 .Refresh
4 End With
Actually I don't know, what the report property in a form/subform stands for
(the help file mentions that this property exists, but not, what it's good
for, and why I can't access the RecordSource property directly) but it worked
reliably over years
In ACCESS 2003 I get the runtime error 2467 (the expression you entered
refers to an object that is closed or doen't exist). What's going wrong
there? What is so different in ACCESS 2003?