I am trying to put a text box on my form where I can just type in what I am searching for (I want to be able to type in information in the search box that may be on any field on the form; I want this text box to have the ability to search any field on the form without me using a combo box where I have to select the field then type in what I am searching for and I don't want to use the Wizard to create a search command that is basically CTRL+F). I am specific to what I want. So if you could help that would be awesome...Here are my field names it would be so helpful if I could just get the code and copy and paste it into Microsoft Visual Basic. Mind you I am working with Access 2003 if that makes a difference.
Search Command is called: cmdSearch
Unbound Search Field is called: txtSearchString
Field Names are as follows:
PhysicianName
PrimaryHospital
Address1
Address2
Address3
CityStateZipCode
Please help only if you can do what I am asking I already know how to do the combo box search and wizard search and don't like either. Plus if I see I have a response I will get excited and then be bummed when realizing that 2 years of trying to figure this out continues:(
Thank you soooooooo much if you can help me with this I wouldn't even know how to explain how awesome it is that I could do this!!!