Displaying Acces rows from a UserForm

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.

Please Login or Register  to view this content.

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

Thank you so much. I will have a go

Hi. Thank you once again.

I have got the query returning results. They are the same as running it in Access apart from it is not excluding rows that have a '*!*. The code is WHERE ...... ((Product.[Product Reference]) Not Like'*!*' )

Please Login or Register  to view this content.

Any ideas why it is ignoring this part?

Many thanks

Tony

Thank you. That's sorted