Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Message Box List

Status
Not open for further replies.

NICKTHEGREEK

Programmer
Sep 12, 2001
11
GB
Is there any way I can create a variable as a recordset, set the variable to an SQL statement and create a message box that displays a list of values returned by a field (or 2) in the SQL statement? Thanks in advanced.

Nick
 
I think you'll have to loop through your recordset, concatenating the fields into a string variable, and then display the string variable in the msgbox. If you really want a 'list' you'll need to add line-feed/carriage-return characters between each value.
"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top