Re: RowSource uses a query

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

Check these articles:

http://www.mvps.org/access/forms/frm0028.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;209595
--
Marsh
MVP [MS Access]


chip wrote:
>I am desperately trying ot get 2 combo boxes to work the way you described
>below: "The value picked in ComboA changes the values that are permitted in
>ComboB."
>
>Can you describe to me how you did that?
>
>
>"Bob Richardson" wrote:
>> My form (data*** view) has 2 combo boxes. The value picked in ComboA
>> changes the values that are permitted in ComboB. The RowSource of ComboB is
>> Q_ClassPick (which of course uses a CombA value). When I first enter the
>> form, I can choose any row and the comboB values will be correct for that
>> row. Unfortunately, the Combo B values for OTHER ROWS will also be based on
>> the ComboA values FOR THE FIRST ROW ENTERED! If I first change a value in
>> Combo A, before using Combo B, then go to Combo B, it works. Of course using
>> Combo B on other rows of the data*** will then be incorrectly limited by
>> the value in ComboA on the first line accessed.
>>
>> Is there a Requery or some other method that will solve this problem? Thank
>> you.
.

Quantcast