|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 14th, 2004, 06:43 PM
|
|||
|
|||
Subform filter on the fly
I have a subform that I am attempting to set a filter value for.
However access claims that the subform does not have a property or method called filter. I know its not a misspelled name or anything as I can execute a refresh on the sub form: Forms!frm_BUDATA!Contacts.Requery However, the statement: Forms!frm_BUDATA!Contacts.Filter = sFilter Generates an error. Can anyone shed some light on this? Thanks! 
|
|
#2
June 14th, 2004, 06:58 PM
|
|||
|
|||
|
Subform filter on the fly
"yagfxgeek" wrote in message
om I have a subform that I am attempting to set a filter value for. However access claims that the subform does not have a property or method called filter. I know its not a misspelled name or anything as I can execute a refresh on the sub form: Forms!frm_BUDATA!Contacts.Requery However, the statement: Forms!frm_BUDATA!Contacts.Filter = sFilter Generates an error. Can anyone shed some light on this? Thanks! The subform *control* you are referencing has no such property, but the form object it is displaying does. Try: Forms!frm_BUDATA!Contacts.Form.Filter = sFilter -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#3
June 14th, 2004, 07:04 PM
|
|||
|
|||
|
Subform filter on the fly
"Dirk Goldgar" wrote in message
"yagfxgeek" wrote in message om I have a subform that I am attempting to set a filter value for. However access claims that the subform does not have a property or method called filter. I know its not a misspelled name or anything as I can execute a refresh on the sub form: Forms!frm_BUDATA!Contacts.Requery However, the statement: Forms!frm_BUDATA!Contacts.Filter = sFilter Generates an error. Can anyone shed some light on this? Thanks! The subform *control* you are referencing has no such property, but the form object it is displaying does. Try: Forms!frm_BUDATA!Contacts.Form.Filter = sFilter And don't forget to follow up with Forms!frm_BUDATA!Contacts.Form.FilterOn = True More efficient would be With Forms!frm_BUDATA!Contacts.Form .Filter = sFilter .FilterOn = True End With -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#4
June 15th, 2004, 03:42 PM
|
|||
|
|||
|
Subform filter on the fly
"Dirk Goldgar" wrote in message ...
"Dirk Goldgar" wrote in message "yagfxgeek" wrote in message om I have a subform that I am attempting to set a filter value for. However access claims that the subform does not have a property or method called filter. I know its not a misspelled name or anything as I can execute a refresh on the sub form: Forms!frm_BUDATA!Contacts.Requery However, the statement: Forms!frm_BUDATA!Contacts.Filter = sFilter Generates an error. Can anyone shed some light on this? Thanks! The subform *control* you are referencing has no such property, but the form object it is displaying does. Try: Forms!frm_BUDATA!Contacts.Form.Filter = sFilter And don't forget to follow up with Forms!frm_BUDATA!Contacts.Form.FilterOn = True More efficient would be With Forms!frm_BUDATA!Contacts.Form .Filter = sFilter .FilterOn = True End With Thank you SO much!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
