filtering a subForm by the textbox

[Neal Griffin]

Hi all,

Was trying to enable a SubForm to filter by the text value in a text
box. E.g. - I type in 'american' into the textbox control and the sub
form filters to show me all entries with the word 'american' in them.

Right now I have enabled a toggle button so that after I type in the
text box, click the toggle button and based on that event trigger a new
query for the controlSource of my subform that uses the .Value of the
textbox as a where clause.

I use a toggle botton because I often have the same search criteria
after moving to the next record on the main form - any suggestions would
be greatly appreciated - thanks, neal

 

[Allen Browne]

I think you are asking to filter the main form, so that it only shows you
records that have the match in the subform? For your example, the main form
should should only records that have 'American' in one of the subform
records?

If so, see:
Filter a Form on a Field in a Subform
at:
http://members.iinet.net.au/~allenbrowne/ser-28.html