Search Query

[NickWren]

So I want a search query that take a tables information and is able to search a field or two.

tblPatientInfo
-PatientID
-PatientName
-PatientPhone
-PhysicianName
-PhysicianPhone
-FacilityName
-FacilityAbbr
-PatientInfo...

qryPatientInfo
(same as above)


qrySearchPatient
-SearchPatientID
-SearchPatientName
-SearchPhysicianName
-SearchFacilityName

I know in the criteria you put

Like "*" & [Forms]![frmPatientInfo]![PatientID] & "*"

but now how do i get that to requery, the form is bound to the query qryPatientInfo
and the search query (pop up form) that you can type in a field from qrySearchPatient and it will find the ones similar



SearchQuery.zip

[NickWren]

Also I have 2 forms;
1 Form has the basic information for any sample that hasnt had a test in the last 3 months and who hasnt been called in the last 3 months for a follow up
the second form takes some information but mostly just tells that database that we made a new call, once that information is updated (that we called them),
we close out of form 2 and go back to form 1, however it doesnt update that we just called that patient; what is the correct vba events to have this "Me.Requery and Me.Refresh" when refocusing on form 1

[Perceptus]

Putting this in the Search Command Button on frmSearchInfo will Open the Patient Info Screen to match the PatientID.

DoCmd.OpenForm "frmPatientInfo", , , "PatientID=" & Me.PatientID

Me.Requery and Me.Refresh achieve different results. Please review
https://support.office.com/en-us/art...5-a472e742366c

[NickWren]

So this didnt really help me out at all, I cant even open the frmPatientInfo without hitting "OK" 4 times. I am wondering if you can just tell me what I need to do to fix the form I have, because this is the approach I am currently trying to take, however it isnt working properly.