Prev: Link Forms with multiple fields
Next: combobox rowsource "All" if more than one in list
From: Jeff Boyce on 23 Apr 2010 18:17
You might not be doing anything wrong ... remember, Cosmic Rays Happen...<g>

Jeff
"szag via AccessMonster.com" <u2885(a)uwe> wrote in message
news:a6f95d5f6cbdc(a)uwe...
> Thanks. Jeff - does this help:
>
> The main form is F_Jobs
>
> There is a tab control in this main form
>
> I am in F_AddJob form (tab page 1)
> I update cboxJobs control (in F_AddJob form)
>
> I want F_JobsQuote (form on tab page 2) to requery (using the result of
> cboxJobs in an underlying query of F_JobsQuotes)
>
> The code included has worked before - just don't know what I am doing
> wrong.
>
> Jeff Boyce wrote:
>>I'm confused ...
>>
>>What is the name of the form you wish to requery?
>>
>>(by the way, if this code is, as it appears, behind a control on a form,
>>the
>>Access 'shortcut' for saying "the form I'm in right now" is:
>>
>> Me.Requery
>>
>>Good luck!
>>
>>Regards
>>
>>Jeff Boyce
>>Microsoft Access MVP
>>
>>> Get an Object doesn't support this property or method error...
>>>
>>[quoted text clipped - 15 lines]
>>>>> this F_JobsQuote form each time a different selection is made on
>>>>> cboxJobs.
>
> --
> Message posted via http://www.accessmonster.com
>


First  |  Prev  | 
Pages: 1 2
Prev: Link Forms with multiple fields
Next: combobox rowsource "All" if more than one in list