Re: macro with applyfilter problem

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

i have made a reply but i dont see it !?
--
de aarde is rond maar de wereld is plat


"Steve Schapel" wrote:

Landmeter,

landmeter wrote:

the macro runs at afterupdate

After Update event of what?

the macro requeries

.... using what syntax, exactly?

the input for the other comboboxes

.... Do you mean the Row Source of the other comboboxes? What exactly is
the SQL view of these queries?

and applies a filter
to the underlaying query

.... Do you mean the query that is the Record Source for the form? What
exactly is the SQL view of this query?

(there is no need to choose from the other comboboxes
the first combobox already filters the query behind the form on one field
choosing a second comboxitem queries on two fields)

.... Can you please give details and examples to illustrate this process?

i have been testing
it seems access keeps in mind the first selected item

.... for example?

and is unable to
change it
using code has the same effect

What code?

--
Steve Schapel, Microsoft Access MVP

.

Relevant Pages

  • Re: How to dump recordset into a table ?
    ... Error Message= "Microsoft Jet-Databasemodule could not find the ... But this method calls the query 2 times. ... Steve Schapel, Microsoft Access MVP ...
    (microsoft.public.access.macros)
  • Re: How to dump recordset into a table ?
    ... Error Message= "Microsoft Jet-Databasemodule could not find the ... But this method calls the query 2 times. ... Steve Schapel, Microsoft Access MVP ...
    (microsoft.public.access.macros)
  • Re: cant edit record anymore in a form
    ... Steve Schapel, Microsoft Access MVP ... guilin wrote: ... > 930pm Changed the query to based on one table -- didn't work either. ...
    (microsoft.public.access.forms)
  • Re: embed a query into a form that has the query criteria
    ... Steve Schapel, Microsoft Access MVP ... You will notice after you close and save the query, if you open it again in design view you will see that Access has re-organised the criteria to suit its own purposes - that's ok. ...
    (microsoft.public.access.forms)
  • RE: Tables and Forms
    ... Dave Hargis, Microsoft Access MVP ... record source of my form to go to the query. ... You will see the name of the table in the Record Source property. ...
    (microsoft.public.access.gettingstarted)