I'm very new to MS Access.
I had this requirement for running a query based on a value selected from a listbox in a Formwith its row source based on a table.
Table A got 3 fields with Project Title as the key field.
Query B will query Table A with three field and I make the data selection of Project Title points to listbox value.
This listbox had the row source reference to the table.
Then there is a cmd button in the form which will call a makro to open the query B.
Here is SQL syntax
SELECT [Project Name Header].[Project Title]
FROM [Project Name Header]
WHERE ((([Project Name Header].[Project Title])=[Forms]![Form1]![listbox]));