Search results

I have a form that is a data entry form. I have learned how to switch it to a filter form by using the Sort & Filter - Advanced - Filter by form. To simplify this I would like to write code (attached to a button) that will do this feature and upon closing the form it returns to data entry again...

Thanks I tryed that, but I still get #name? error.

[product id] is from a combo box on the subform. That is where I select what cabinets in need. Such as B18 for base 18". Also [product id] is a field in the table oakhill cath which matches the B18. Thanks for helping me

Sorry for the typo, yes it was suppose to be a &. Oakhill cath is one of the names that can be selected from the combo box "line". Then I have corresponding tables for each of the lines, therefore oakhill cath is also a table.

I have a form [order details] that contains a subform [sbforderdetails]. This form is for estimating cost of job. On the main form is a combo box [line] in which the user selects which line of cabinets the estimate is for. On the subform user selects a [product id] and i want the...