On an Access form I want to have a list that is pulled from a query or table using SQL statement.
I am using the report to create an invoice so data will be pulled from the "Invoices" table and
the "Invoice Details" tables using the ID of the invoice.
So I want to use code to build a SQL statement eg "Select Description, Unit Price, Amount From [Invoice Details] Where InvoiceID = " & oID
How do I achieve this?