Filtering subform using text boxes?

[NewShoes]

Hey all,

I found a great solution on this forum (http://www.access-programmers.co.uk/forums/showthread.php?t=103312) to enable me to filter a subform based on text boxes in a form. However, I would like to (need to!) use the autofilters in the subform. By this I mean the ones on the heading of the columns, like you get in Excel. Is there anyway to achieve this? or does the unique way in which this query works prevent me from doing this?

Many thanks,
-NS

 

[boblarson]

You can use the autofilters in the datasheet but you have no control (at least I've never seen that ability) over them.

 

[NewShoes]

Thanks Bob, however I'm not sure you know what I mean. I;ve uploaded 2 pics..

The first is what it looks like when using the query

The second is what I would like it to look like.

Thanks,
-NS

 

[boblarson]

Don't post images to Image Shack or any other public photo sharing site as those are blocked for me (and several others) by my workplace. Please upload them directly here on the forum. See here for how:
http://www.access-programmers.co.uk/forums/showthread.php?t=194680

 

[NewShoes]

Thanks Bob....

The pic below is what happens with the query.

The pic below is what I would like to happen (and does happen when I dont use the query).

Thanks,
-NS

 

[NewShoes]

I guess this cant be done then?

-NS

 

[boblarson]

That's correct because of Multi-select field behavior.

 

[NewShoes]

Thanks for confirming Bob. Please can I ask you this..

As I cannot select multiple Surnames using the autofilter, is there a way I can do it from a form control? I know how to refer to text and combo boxes but these obviously only allow you to select one Surname. I'm aware of List boxes but have no idea if this is the right solution or how to implement them!

Any help or nudge in the right direction would be great.

-NS

 

[boblarson]

See if this helps:

http://www.baldyweb.com/multiselect.htm