How to get a grid view as a subform

  • Thread starter Thread starter Max Moor
  • Start date Start date
M

Max Moor

Hi All,
I have a form in which I want to have a gridview of a query as a
subform (so I can change its record source, requery, and change the
displayed data. The only wayI've made a datasheet view in the past is to
shove a bunch of text boxes together. Is there a simpler way to do this?
Is there a control I have use that I don't know about?

- Max
 
Max,

Try the list box, as an example:

With Me.lstMyListBox
.RowSource = sql
.BoundColumn = 1
.ColumnCount = 11
.ColumnWidths = _
"0 in ;" & _
"0 in ;" & _
"1 in;" & _
"1.5 in;" & _
"0.65 in;" & _
"1.5 in;" & _
"0.65 in;" & _
"0.65 in;" & _
"0.65 in;" & _
"0.65 in"

.ColumnHeads = True
Call .Requery
End With
 
Back
Top