Hi,
I didn't explain it right in a previous post so I will try to be as specific as I can. I have made a database in which I have imported 901 entries. Each entry includes these fields: ID, Main_Certification, Other_Certifications, Company, Country, Address_City, Telephone, Mobile, Fax, Site, Email, Contact. I added a textbox and a SEARCH button. The textbox is about Country.
Let's just say I'm looking for a company in Greece, I type Greece in the textbox, press SEARCH and I get 17 results. So far so good, the SEARCH for the Country works. Now, from these 17 results I want to get the ones that have ABS in Main_Certification this is why I added an Option Button named ABS. When I click on the ABS option button everything disappears and I don't get anything! I'm missing something and I don't know what it is.
This is the code for the textbox and the Option Button
Textbox
Option ButtonCode:Private Sub btnSearch_Click() Me.Filter = "[Country] Like '*" & [txtCountry] & "*'" Me.FilterOn = True End Sub
To sum it up, I want to look for a company using the Country search and after I get the results I want to click on ABS to get the ones with the ABS certification. I have 3 more options to add using the Option Button and they will do the same thing as ABS does.Code:Private Sub optABS_Click() Me.Filter = "[Main_Certification] Like 'ABS" & [optABS] & "ABS'" Me.FilterOn = True End Sub
Any help would be really appreciated. Plus, what is best to use: Option Button or Option Group?
Picture shows what happens when ABS is clicked. The Main_Certification field is filtered but no results at all!