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