Re: Filtering records based upon another table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Brian,

Thanks for the further information. Can you also say please what "do a macro to filter" means? What are the actions in this macro? And where is it being run from? And what is is supposed to do?

--
Steve Schapel, Microsoft Access MVP


Brian O''Malley wrote:
Thanks Steve. I have a contacts database with address info, etc. of business associates. I store the tiltes in a seperate table that a combo box displays on the form. When I do a query based on title, the dynaset returns accurately without any problems. When I do a macro to filter based on the query it does not return the data. (it will usually display a box asking me to enter "title.titles" or something similar. 
.

Relevant Pages

  • Re: stop macro before opening report from form
    ... filter and converted all the macto commands to vba that solve the ... Unless your reports refer to the query parameters, ... Limiting a Report to a Date Range ... You can use it in a macro. ...
    (microsoft.public.access.forms)
  • Re: Filter for THIS WEEK only
    ... Jerry's idea was to put it in the query, in which case your form is ... If you want to option to filter it, the code is *much* more flexible than ... I tried just putting as the macro ... > statement Jerry suggested, and it didn't work (please see my reply to ...
    (microsoft.public.access.queries)
  • Re: Filter for THIS WEEK only
    ... putting it in the underlying query or form itself is because the form opens ... So I have the combo box set to run a macro On Update. ... Right-click the command button you use to filter this form, ... > Access opens the Code window. ...
    (microsoft.public.access.queries)
  • Re: open form, go to specified record
    ... Presumably the records in the second form are identified by a unique ... argument of the OpenForm action in your macro. ... and go to that record either with a filter or query. ...
    (microsoft.public.access.macros)
  • Re: auto filter
    ... I would delete the macro that you created, ... it can't find a filter, and it continues to the end. ... Dim rownum As Long, colnum As Long ... I'm not proficient with excel macros ...
    (microsoft.public.excel.misc)