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.
|
