Search Form

[whojstall11]

basically im trying to have the person looking for data, type in any part of information of the patient they are looking such as: name dob etc.............. when typed in the Search Form the results go to the Search Results subform then when you find the data you are looking for it suppose to send you to the Patient Data form so they will be able to edit it or to look at all thier information.

[pbaldy]

With a number of optional criteria, I tend to build SQL in code as done in the sample db here:

http://www.baldyweb.com/BuildSQL.htm

[whojstall11]

yea i have but it doesnt work can you look at the attach file it is in Access 2007

[pbaldy]

For starters, because of the inadvisable spaces in your names you will need to bracket them:

[File Number]

[pbaldy]

Oh, and General is a reserved word and will also need to be bracketed.

[whojstall11]

ok ill try that

[whojstall11]

Ok did that now its asking me to enter a parameter value? Then when i enter in any value it gives me a blank form?

[pbaldy]

What specific steps are required to recreate the error. I just tested and it worked fine.

[whojstall11]

Now when you double click on the record that came up it takes me to a blank record. Its suppose to take me to take me to the record i double clicked on on the PatientData form

[goodguy]

1. Change the line of code where you open the PatientData Form to wrap the value of MRN in single quotes as your MRN field is text.
2. You are still referring to the MRN control as MRN1 in the new form whereas it is called simply MRN. Change it.
3. You have unnecessary spaces in the OpenForm command. Remove them.

[whojstall11]

LIKE this
DoCmd.OpenForm "Patient Data", , , "'MRN' = " & Me.lstCustInfo, , acDialog

(and i change my patientdata form's name back to patient data already )

says data type mismatch in criteria expression

[pbaldy]

This demonstrates the correct syntax:

BaldyWeb wherecondition

You've got quotes around the field, not the value.

[whojstall11]

Omggggggggggggggggggg thank you

[pbaldy]

Happy to help. Is the issue resolved?

[whojstall11]

Yes solved perfect thank you