Hello all! I am trying to filter a column (PPO#) in a subform using an unbound text box and a button. The subform (frmAssignPO#) is on the second page of a tab control (this page is called pgMaterial). My code for the On Click (Where Condition) is as follows:
[PPO#] Like "*" & [frmAssignPO#].[Form]![PPO_Filter_txt] &"*"
The text box is called PPO_Filter_txt.
I get an error when I try to filter using this code that says my form isn't bound to a query however I have the RecordSource property filled out and pointing to a query called qryAssignPO#. Anybody know what I am doing wrong or another way to filter this column? Thanks for your time.