4 Replies - 474 Views - Last Post: 15 August 2017 - 09:19 PM

#1 adminSCR  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 14-June 17

Would like a search button that searches 2 key words at a time

Posted 14 June 2017 - 03:41 PM

I created a work database that tracks patient information. I created a form (Patient Form)which has 5 tab controls. I want to create a search button inside the Patient Form to the right of the tab controls by Last Name (PtLast) and First Name (PtFirst). I already have an add button, delete button, menu button and save button and each record is a patient.

I do have a search button but it only searches the last name. I have to put the cursor on the last name text box and press search and the find and replace box shows up and you just type the last name and that person appears in the form. e are getting so many people with the same last name that we have to press next a lot to get to the one we want, very time consuming. I want the search button to search in the patient form and just go to that patient and still be able to go to the bottom and see all the records, is there a way to do this? I don't know any programming in database, I have done a few things but it was copying and pasting from others online that post how to do it.

I also, eventually would like to create an audit trail but I know that is definitely programming.

Any feedback would be much appreciated. Thanks so much and Cheers, Lori

Is This A Good Question/Topic? 0
  • +

Replies To: Would like a search button that searches 2 key words at a time

#2 wseng92  Icon User is offline

  • D.I.C Regular

Reputation: 9
  • View blog
  • Posts: 288
  • Joined: 23-September 15

Re: Would like a search button that searches 2 key words at a time

Posted 15 August 2017 - 02:43 AM

You're asking in a wrong forums
Was This Post Helpful? 0
  • +
  • -

#3 andrewsw  Icon User is online

  • the case is sol-ved
  • member icon

Reputation: 6378
  • View blog
  • Posts: 25,769
  • Joined: 12-December 12

Re: Would like a search button that searches 2 key words at a time

Posted 15 August 2017 - 05:51 AM

Find the appropriate forum for your question, not in the "Introduce Yourself" section.
Was This Post Helpful? 0
  • +
  • -

#4 adminSCR  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 14-June 17

Re: Would like a search button that searches 2 key words at a time

Posted 15 August 2017 - 06:33 AM

Got the message. Thanks.
Was This Post Helpful? 0
  • +
  • -

#5 Skydiver  Icon User is offline

  • Code herder
  • member icon

Reputation: 5894
  • View blog
  • Posts: 20,114
  • Joined: 05-May 12

Re: Would like a search button that searches 2 key words at a time

Posted 15 August 2017 - 09:19 PM

It is definitely do-able if you are willing to write code. It sounds like you want to do that using the native capabilities of your current database. Since you did not mention what database you are using, it makes it very hard for people to posit whether there maybe something built into your database that does what you want.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1