Search results

Here is a pic of the form if that helps. not formatted yet, just trying to get it to function first.

Yeah I guess I could do that, 1 was just hoping to have it all on one form. I was going to use 'tabs' but had the same 'mainform'/'subform' issue when trying to filter the subform.

Hello all, needing some help on this please. I made a form based on a products table query. Made a searchbox and button, works great. code for the search function is as follows. Private Sub Search_btn_Click() DoCmd.ApplyFilter "", "[PartNumber1] Like ""*"" &...