How to link Access List Box row Source SQL query to a form field
Posted on 2014-09-08
I've got a list box on a form in which I want to show a list of related values filtered by a value on the form.
The form field is fldItemID in a form called MyFormName
I've tried setting the row source as
"SELECT tblItems.fldID, tblItems.Name FROM tblItems WHERE tblItems.fldID = " & me.fldItemID & " ORDER BY tbltems.Name;"
I've also tried using forms!MyFormName!fldItemID as the value but that doesnt work either.
What am i doing wrong.
(Access 2010 Project database)