Use VBA to change a criterion

Topic

New Reply

Using VBA, how can I change a criterion in the source recordset of a subform? Example: change a criterion for a field from True to False.
Many thanks.

Reply | Quote

Replies

Does using the Me.Filter command work?

Reply | Quote

Yes, it does, but only from within the subform. I was trying to effect the change from the main form using Forms!mainform!subform.filter and that does not seem to work. I can muddle on, but it is less elegant than I had hoped. Thanks for the response.

Reply | Quote

Yes, it does, but only from within the subform. I was trying to effect the change from the main form using Forms!mainform!subform.filter and that does not seem to work. I can muddle on, but it is less elegant than I had hoped. Thanks for the response.

I think you may also have to set .FilterOn = True

Reply | Quote

An option box in the subform header got the response I needed.
Thank you all for your help. It is so very GOOD to know I have access to such a resource!
Sanora

Reply | Quote