Populating list box with column heading?

[kawi6rr]

Just like to say thanks in advance for anybody who can help me.

I have a listbox that I’m populating from a query string that’s based on two date fields beginning and ending dates. What I would like my list box to look like is this


firstName | lastName | MI department | fppeDate
John | Doe | D. | someDept | 1/1/10
Jane | Doe | D. | anotherDept | 2/1/10



Unfortunately what shows up is John and Jane with no heading and no other data requested in the query string.

John
Jane

Here’s the code I’ve come up with so far but am fairly new to this.

Dim Beginning As Date
Dim Ending As Date

Beginning = Me.txtBeginDate.Value
Ending = Me.txtEndDate.Value

If Not IsNull(Beginning) And Not IsNull(Ending) Then
Me.OutPut.RowSource = "SELECT firstName, LastName, department, fppeID, fppeDate FROM FPPE WHERE fppeDate >= #" & Beginning & "# AND fppeDate <= #" & Ending & "# ORDER BY " & fppeDate
'Me.OutPut.RowSource
Else


MsgBox "you need to enter a beginning and end date!"
End If

Does anyone have any ideas?

[kawi6rr]

Problem solved.
Properties
-format
-columns = 5
-column heads = yes

Works like a charm