I have a suppliers table and a contracts table which is a one to many relationship. I currently have a combobox set up where I select a supplier, all contracts for the chosen supplier are displayed in my subform and on click I have some vb code to display an error msg, in this msg I want all the contract id nos to be listed in the msg ie The following contract(s) due to expire
1,5,8,9 etc

I have this working but access is only picking up the last record in my subform. How can I change this so access knows I want to look at all the records in my subform for that supplier?

If this scenario is not possible does anyone know of another option where I can achieve the same results? maybe something along the lines of changing the colour of text(again it would have to look at all the records)

Thanks in advance

Post the code you are using.

The code is pasted in my original post where I had my intial problem. For anyone who wants to take a look it is in

General Forum
topic - Msgbox

Thank you