A
Atlas
A2003 + ms sql server 2000 + adp
I have a continuos form whose contents are populated dinamically (whenever
two comboxes on the form change values) with a "select " statement assigned
to the recordsource property. The form also has a subform (datasheet view)
linked by child/master fileds properties.
It all works perefectly.
Now trying to set a filter on the subform programmatically, I've put the
following code in the form's Sub dealing with "select" update:
With Me![subformcontrolname].Form
.Filter = "[Data] >= '" & value '******** it's a date..............
.FilterOn = True
End With
Unfortunatelly I get errors like:
The column prefix 'subformcontrolname'
does not match with a table name or alias name used in the query
or
runtime error '7874'
[sqlserver databasename] cannot find the object "[selectstatement]"
I've tried to disable the link child/master property, with same
results......
Any hint?
I have a continuos form whose contents are populated dinamically (whenever
two comboxes on the form change values) with a "select " statement assigned
to the recordsource property. The form also has a subform (datasheet view)
linked by child/master fileds properties.
It all works perefectly.
Now trying to set a filter on the subform programmatically, I've put the
following code in the form's Sub dealing with "select" update:
With Me![subformcontrolname].Form
.Filter = "[Data] >= '" & value '******** it's a date..............
.FilterOn = True
End With
Unfortunatelly I get errors like:
The column prefix 'subformcontrolname'
does not match with a table name or alias name used in the query
or
runtime error '7874'
[sqlserver databasename] cannot find the object "[selectstatement]"
I've tried to disable the link child/master property, with same
results......
Any hint?