Re: Parameter Query Help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Just a style difference, I think, but I would always use the combobox's After Update event *unless*, as Doug says, the query needs to refer to more than one control on the form.

--
Steve Schapel, Microsoft Access MVP

Douglas J. Steele wrote:

Often you'll have more than one control linked to the query. If you put the logic in the AfterUpdate of the combo box, you might not have supplied all of the values yet. Even if you've only got one parameter now, you might need more in the future, so it's probably simplest to start with having a button to signify you're done.

.

Relevant Pages

  • Re: Can an event on a form be called from a module?
    ... see that Access uses this kind of "Form_" prefix to refer to the module. ... > VBA code in the module enters a value in the COST field of the form, ... > would like to call the Cost field's After Update event (Private Sub ...
    (microsoft.public.access.modulesdaovba)
  • Re: One-eyed Scottish Idiot
    ... After all, we don't refer to Doug as a "scrounging, incontinent old ...
    (uk.transport)
  • Re: Darling calls for urgent review of biofuel policies
    ... Sorry, but Doug has ruled that Message IDs don't work, you'll have to ... find another way to refer to those posts. ...
    (uk.transport)
  • Re: Die-in at TOTAL Oil HQ over Burma links
    ... Doug wrote: ... apologised in a suitably grovelling fashion for daring to refer to Miles ...
    (uk.transport)
  • Re: How odd
    ... uk.environment used to refer to Doug as "the Catford Cunt" e.g. ... I'm confused, however, because Doug doesn't live in Catford - he's ... >Whereabouts in Morocco were you? ...
    (uk.transport)