Search results

Thanks for all your help. The first combo box cboSalesRep works perfect and filters the sheet and only shows records matching the sales rep that picked in the combo box. I am still getting a type mismatch after I select the customer from the cboCustomer combo box. In the query and table the...

The lookups for each combo box is coming from a query. Both lookups have one column. I tested it with the search for record macro and it goes to the first instance of the record in the datasheet but what I want to do is only show those records where the sales rep and customer name match whats...

ok went back and renamed the controls. The sales rep will always have a value as I am going to have it set and disabled before the end user gets the database. So here is what I have now: Both combo boxes are in text form. It give me a runtime error '13' Type mismatch message. Private Sub...

I am not sure what I am doing wrong. Just need to filter records to only show whats selected in the sales rep combo box and and the customer combo box. This should be pretty simple. Here is what I have: Private Sub Combo60_AfterUpdate() Me.Filter = "[Customer]='" & Me.Combo60 & "'" And...