Search results

I have 2 combo boxes on a form that are both bound to the same data source. The combo boxes are labeled Contact 1 and Contact 2. I have a table full of contacts and a project data table but I may have more than one contact for a project. When I enter a value for the second combo box, the first...

I have several fields on a form that stores the ID for the field. I use my form to filter records and then generate the report from a button on the form so it is also filtered. How can I get the value instead of the ID to show on the report? I would like to keep the ID showing on the form and...

Thank You very much. That worked great. I just had to switch some things around with my table for that code.

I am storing the ID. I just have the code as it is because that was what I found online. How can I switch it to search for numbers?

Thanks for the suggestion. I tried using Or & AND but they both caem up with a runtime error 13 Type mismatch. I am just learning VBA so I'm not really sure what to look for to fix that. I will keep trying though. Does anyone have any other ideas?? Oh and for my tables, I do have a central...

I have a split form that I am using to filter through records with an unbound text box. I have a field called Project Type that I use to classify different projects. Some of the categories are Wind Damage, Hail Damage, Roof Damage, etc. My code for filtering is below Private Sub...