Dynamically search multiple fields (problem)

[johnob]

Hi all,

Im trying to make a find page that looks up 7 fields and after reading about the Dynamically search multiple fields i downloaded the sample and changed a few things. But I have a few problems .

1) If you open the FRM_SearchAll from the navigation pane , it will not show the detail form by dbl_click or view button also will not show the picture .

2) If you open it the navigation form , it has the following error

Forms!FRM_SearchMulti!SrchText

before you start it.
3) As above it will not show the detail form by dbl_click (it has Error)

Run time error : 3075
Syntax error (missing operator) in query expression '[Food]Snack a Jacks'.

4) If you try to view detail form with the button (the error comes up)

Syntax error (missing operator) in query expression '[Food]Snack a Jacks'

5) also will not show the picture .

Can anyone help this this .

See attached file .....

thank you.

 

[johnob]

anyone got any ideas ?

 

[madefemere]

Hello,

I will give you some responses without the case of the picture

1- When you put your FRM_SearchMulti in the navigation pane, it becomes a subform. So the syntax [forms][FRM_SearchMulti]![SrchText] of criteria in the query QRY_SearchAll is bad. If you use the control, you must write [forms]![Main page]![FRM_SearchMulti].[Form]![SrchText].

2- For your 3rd and 4th points , as [Food] is a string, you must use it between comas in the criteria :

stLinkCriteria = "[Food]='" & Me![SearchResults] & "'"

For the pictures, I am sorry because I don't use attachments fields to put picture in a db.

Have a good continuation

 

[johnob]

got most of the problems fixed, just need to get the pictures now