Multiple Results into one Text Box 1

[Elvis72]

I have a form that is setup to find as you type on various fields in the form.

Works just spiffy.

But I need to add the Experience criteria to the form.

The experience criteria is setup as following:

TblExperience
ExperienceID
Experience

TblResumeExperience
ResumeID
ExperienceID
WorkerID

TblResumes
WorkerID

So, when I put it in a subform on the Resume Main Form it comes out like this:

Experience
Pipe Fitter
Start-up
Commissioning

I need to have them listed in one field on a form that I can do a search for?

If not can you point me in a direction to search?

Thanks so much for your time!~

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Elvis72]

Thanks for the link!~

I have the following for my query:

SELECT [TblResumes Query].WorkerID, [TblResumes Query].[First Name], [TblResumes Query].[Last Name], [TblResumes Query].Country, [TblResumes Query].[Career Title], [TblResumes Query].Nationality, [TblResumes Query].[Resume Link], [TblResumeExperience Query].Experience, [TblResumeExperience Query].[Experience ID], (sELECT ExperienceID, Concatenate("SELECT Experience FROM tblExperience WHERE ExperienceID =" & [ExperienceID]) as FirstNames FROM tblResumeExperience) AS Expr1
FROM [TblResumes Query] LEFT JOIN [TblResumeExperience Query] ON [TblResumes Query].WorkerID = [TblResumeExperience Query].WorkerID;


And I am getting this error message?

You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.

Any Ideas???

 

[PHV]

What about this ?
SELECT WorkerID, [First Name], [Last Name], Country, [Career Title], Nationality, [Resume Link]
, Concatenate("SELECT Experience FROM tblExperience E INNER JOIN TblResumeExperience R ON E.ExperienceID=R.ExperienceID WHERE WorkerID=" & WorkerID) As Experiences
FROM [TblResumes Query]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886