Assigning SQL to a string variable

[Softweb]

Can anyone tell me how to assign the following SQL to a string variable in MS Access 16 so that it can be assigned to a ListBox RowSource. I’ve tried it unsuccessfully but I think my syntax is wrong.

SELECT tblSubjectToday.SubjectToday, tblSubjectToday.IsPending, tblSubjectToday.Training_ID
FROM tblSubjectToday
WHERE (((tblSubjectToday.Training_ID)=[Forms]![frmClient]![frmTraining].[intTrainingID]));

I want to do the following:

strRowSource = ??

lstList.RowSource = strRowsource


Thanks Chris

 

[Minty]

It's pretty straight forward Mr Baldy has an excellent little guide here http://www.baldyweb.com/buildsql.htm

If you get stuck post up what you tried and what error you were getting in the debug window.

 

[Softweb]

Thanks Minty that's really useful. I'll try it out. Chris