Forum home » Delegate support and help forum » Microsoft Access Training and help » Access VBA queries subforms
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access VBA queries subforms
Resolved · Urgent Priority · Version 2003
Reply Thu 6 Nov 2008, 11:54Delegate Anna said...
Anna has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Access VBA queries subforms
Hi,
I have a subform which has no related fields to the form it has been placed on. I wish to filter the records in the subform when a user clicks a button. i have placed the following code on the onClick event of the control
DoCmd.ApplyFilter "queryName"
this works fine when the subform is opened as a form not a subform but will not work when it is a subform.
Please help
Anna
For upcoming training course dates see: Pricing & availability
RE: Access VBA queries subforms
Hi Anna
Thanks for your query. The main remit of the forum is to assist delegates with any topics they covered during their training.
Naturally we would love to get involved in every post but it is not always practical.
From what you have described, this looks more like a consultancy requirement and although once we have had a chance to look at your sample files the work may only take half an hour, it could also take longer.
We will let you know what we can do and the associted costs if you wish to progress this, just let us know.
Regards
Jacob
|