Re: Requery a list in aanother form ?

Tech-Archive recommends: Fix windows errors by optimizing your registry


"Marshall Barton" <marshbarton@xxxxxxxxxx> wrote in message
news:4g09j1tkd8p0o0f3lkqlfed4imgl6gmjnc@xxxxxxxxxx
>>> kelvin H via AccessMonster.com wrote:
>>>>Is it possible to Requery the result of list which is in another form ?
>>>
>>>
>>"Marshall Barton" wrote
>>> Sure, as long as the other form is open, just reference the
>>> object that you want to operate on. If it's another form,
>>> use something like:
>>> Forms!otherform.Requery
>>>
>>> If it's a list/combo box control:
>>> Forms!otherform.the control.Requery
>>
> Amy Blankenship wrote:
>>If that doesn't work, you may want to try something like
>>
>> Forms!otherform.Controls("the control").Requery
>>Or
>> Me.tableName_Subform.Controls("the control").Requery
>>
>>I found recently that this was the only way I could get it to work for me.
>
> Amy, FYI,
> The syntax:
> Forms!otherform.Controls("the control").Requery
> is equivalent to:
> Forms!otherform.[the control].Requery
> and the square brackets are only needed when the control
> name contains a non-alphanumeric character (e.g. a space).

That may be so, but my experience was that one worked and one didn't :-).

-Amy


.

Relevant Pages

  • Re: References for VBA
    ... Amy Blankenship nous racontait que: ... >> in Access, it's the mso constants that aren't defined, so ... ... > Why would that give a good indication of the reference that was ... Jean-Guy Marcil - Word MVP ...
    (microsoft.public.word.vba.userforms)
  • Re: References for VBA
    ... > Amy Blankenship nous racontait que: ... >>> in Access, it's the mso constants that aren't defined, so ... ... >>> that might be missing. ... >> Why would that give a good indication of the reference that was ...
    (microsoft.public.word.vba.userforms)
  • Re: Eval function
    ... >> Amy Blankenship wrote: ... >>>control value on the calling form when it is closed. ... >>> Dim arrArg As Variant, strForm As Variant, strEval As String ... there's got to be a way to reference a form when the full path ...
    (microsoft.public.access.formscoding)
  • Re: Speeding up wor flow
    ... Amy Blankenship wrote: ... > Access does not seem to accept the paste of the multiple columns. ... RBrandt at Hunter dot com ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)