Search access database with multiple criterias
Hey,
My first time here.
Im completly new to programming and i guess the way i have done the application might not be right (most of the code i have got from somewhere along time ago)
I have a small problem that i cant figure out. I have a windows form with 2 textboxes and a button. its connected to an access database.
I have no trouble searching the database just using 1 textbox.
But when im trying to get 2 searchcriteria to work everything goes bad, well sorta it works in a way but not as i want to.
when i search for just Firstname, i want everyone with that firstname to come up, and ONLY them.
when i search for lastname, i want everyone with that firstname to come up and ONLY them.
And ofcourse when i put something in both boxes i want the perfect match person to come up.
As i said im really new to this and this might be something obvoius but my brain limits me:)
attaching sourcecode