Prev: Can a Table be opened in datasheet view from a form
Next: How To Access From VBA A Tables Row Lookup Row Source
From: Jan :) on 2 Feb 2010 16:36

"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:8h3hm5dt9scqdkftqmh95r3nql7qg4kns5(a)4ax.com...
> On Tue, 2 Feb 2010 11:06:32 -0800, "Jan :\)" <abuse(a)localhost.invalid> wrote:
>
>>
>>"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:vkpgm5pt5qc1130iqukkvtouulqb7m4or5(a)4ax.com...
>>> On Tue, 2 Feb 2010 07:07:57 -0800, "Jan :\)" <abuse(a)localhost.invalid> wrote:
>>>
>>>>> You have not said what you're using as the RowSources of these combo boxes.
>>>>> Are they value lists? lookup tables? Select Distinct from your main table? or
>>>>> what?
>>>>
>>>>RowSource is Select Distinct, such as:
>>>>SELECT DISTINCT tblMeds.Provider
>>>>FROM tblMeds;
>>>
>>> In that case just requery each Combo Box individually in the Form's
>>> AfterUpdate or Current event. Overkill and will usually waste time but it'll
>>> work.
>>
>>Thanks, John. I appreciate your time and help.
>>
>>Jan :)
>
> You're welcome. It's great to see your smiling face!

Wasn't sure you'd remember me. I sure do miss you all! :-)

Jan :)
> --
>
> John W. Vinson [MVP]
First  |  Prev  | 
Pages: 1 2 3
Prev: Can a Table be opened in datasheet view from a form
Next: How To Access From VBA A Tables Row Lookup Row Source