Hi,
I think I know why I cannot use multiple selection.
As I described eariliy, I use combo in the main form to filter the value
in
subform. In the subform>Data source> in query view, I use criteria in the
query. i.e. "Like form!combo2.value".
Could this be the reason?
thanks.
"Boon" <boonyawat.la-ongthong@[EMAIL PROTECTED]
> wrote in message
news:O73Ha7XVJHA.4876@[EMAIL PROTECTED]
> Hi,
>
> I use Access 2007.
>
> The default view is datasheet. Strange huh?
>
> - I didn't use link master field or link child field.
> - I can sort, use filter text option, but no list to choose multiple
> selection.
>
> I have noticed for a while that in Access, when you open a table when
try
> to filter a field, if the value in that field is too many, it will not
> have a multiple selection. For example, I can do multiple selection on
zip
> codes, states, countries. But I cannot do multiple selection on invoice
ID
> (#######). It is like there are too many different values.
>
> Thank you,
> Boon
>
>
>
> "Clifford Bass" <CliffordBass@[EMAIL PROTECTED]
> wrote in
message
> news:4C57FE85-1DE9-41A9-A2D0-0BBE6DB04852@[EMAIL PROTECTED]
>> Hi Boon,
>>
>> Oops, I meant the filter options when I said sort. Regardless,
when
>> I
>> replicate what you describe, I do get the option to select specific Zip
>> codes
>> for filtering. What version of Access are you using? Double-checking:
>> Is
>> the Default View property of your subform set to Datasheet?
>>
>> Clifford Bass
>>
>> "Boon" wrote:
>>
>>> Hi Clifford,
>>>
>>> I didn't use Link Master Fields or Link Child Fields in my subform.
>>> Instead,
>>> I use Record Source, and making query in it.
>>>
>>> I set up the subform as datasheet, and I am able to see and use the
sort
>>> option.
>>>
>>> The situation is this... I have combo State in the main form. Says I
>>> choose Wisconsin in the combo, the subform will display all the
zipcodes
>>> in
>>> WI. I then can sort this zipcode in the subform. (This has been done
>>> already). But, I cannot filter it to see just one zipcode. (this is
just
>>> an
>>> example, it might seems weird to filter to see only one zipcode).
>>>
>>> Or.... The only way to see the filter in the subform is to do the link
>>> master fileds and link child fields?
>>>
>>> Again, by filter I mean to be able to do multiple selections.
>>>
>>> I appreciate your helps, thanks.
>
>
|
