Hi,
I have the following message box which works fine for the 1 field only
Results (Message box appears like..)Code:Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("QryCalcWSM") If Not rs.EOF Then MsgBox " Business Options Based on WSM Score " & rs.Fields(0) End If
Business Options Based on WSM Score MPESA
However, I have a list of businesses extracted on QryCalcWSM;
MPESA
SUZUKI
SAFARI
TELECOM
Now, I want to display on the message box
Business Options Based on WSM Score
MPESA
SUZUKI
SAFARI
TELECOM
any help please!! Thank you