I have a 4-column list box. I am trying to create a select query that will use the contents of two columns in the list box as criteria.
For now the list box is called List0 and is on a form called frmMakeModelFix1. The SQL statement I have tried is:
SELECT CabinetRecords.Manufacturer, CabinetRecords.Model, CabinetRecords.Type, CabinetRecords.Size, CabinetRecords.In_Use
It is supposed to select the records from the table CabinetRecords where the Manufacturer is the same as the Manufacturer
in the selected list box record. Once it works, I will add criteria to further specify that the Model must be the same as that in the
selected list box record.
It doesn't work and gives me the message: "Undefined function '[Forms]![frmMakeModelFix1]![List0].Column' in expression"
It works with the bound column when you don't need to specify the column, just the list name.
Will what I'm trying to do work?