userform needs a subform
Posted on 2011-02-23
excel 2003 vba
What I have:
A userform but trying to display items being rectrned in a recordset(from access) like a subform. On my userform.
What I need for now...
I have a listbox to hold my records in the return recordset.
However it is not displaying them properly. Like a list...
they are just on one single line.
'Create a Snapshot Type Recordset from the SQL query
Set rstFromQuery = dbsEAIQuote.OpenRecordset(strSQL, dbOpenSnapshot)
'Move to the last record in the recordset
.ColumnCount = rstFromQuery.Fields.Count
.Column = rstFromQuery.GetRows(rstFromQuery.RecordCount)
Maybe the listbox is the only way to create a subform in excel ?
anyway I need all records to show as a list in listbox1 ?