How would I go about listing a record in the immediate window, ie

If i had a table called tblCustomer, with 3 fields, customerID, Firstname and lastname

CustomerID Firstname LastName
1 Debbie Smith
2 Mark Jones
3 Nora Batty

if i said "Select * from tblCustomer where Customer ID = 1" What I want is to be able to produce a list int he debug window to check the values (its just something I am playing with)

This is what I want the results to be

CustomerID: 1
Firstname: Debbie
LastName Smith

any help appreciated.

Debbie