Hi I was hoping for some help to be able to show a series of rows for a specific product reference (usually 3 or 4 rows) from my access DB in a userform.

My access DB is called ActinicCatalog.MDB. I have the query in Access that brings back all the rows for all products.
SELECT ProductProperties.nType, ProductProperties.nPropertyID, ProductProperties.nValue1, ProductProperties.bFlag1, ProductProperties.sProductRef, Product.[Product Reference], Product.[Short description], ProductProperties.nSequence
FROM Product INNER JOIN ProductProperties ON Product.[Product Reference] = ProductProperties.sProductRef
WHERE (((ProductProperties.nType)=8))
ORDER BY Product.[Product Reference], ProductProperties.nSequence;
I have 2 big stumbling blocks:

The first is how to incorporate this into my userform (calling the query and displaying the results in a table).

The second is I want to pass to the query a specific product reference ( Product.[Product Reference] ) so I just get the rows for that product

Being honest I have not tried to get data from an Access DB into Excel before so a basic code structure would really help to get me on the right path.

Many thanks

Tony