Re: Recalc or requery?

Tech-Archive recommends: Speed Up your PC by fixing your registry

The Requery method tells Access to go and re-fetch the data underlying the
query since something may have changed since it was last queried (or form
opened).


"Frank Martin" <paul@xxxxxxxxxxxxxx> wrote in message
news:OBSZX4UbFHA.1040@xxxxxxxxxxxxxxxxxxxxxxx
> I wonder what the difference between these two are?
> Sometimes one works and sometimes the other.
>
> When I am testing a form with combos I check the requery/recalc by
pressing
> the F9 button and then try to resolve this back to code with, eg,
Me.Requery
> or Me.Recalc or Combo(x).Requery etc.
>
> I get inconsistant results and sometimes we are reduced to pressing the F9
> key to update a Combo rowsource query!
>
> Is there some definitive solution?
>
> Please help, Frank who has Access2000
>
>
>


.

Quantcast