D
Derek
I am trying to populate an unbound continuous form but it does not seem to
work. I have setup a generic form to test this and have set up an unbound
field named child. I have set the form to continuous view and inserted this
code on open
Private Sub Form_Open(Cancel As Integer)
Dim test As String
test = "SELECT tbl00ProjectsHiearchyLevel2.Level2 AS Child FROM
tbl00ProjectsHiearchyLevel2"
Forms!tt.RecordSource = test
End Sub
When the form opens it correctly shows me the child field box 3 times (all
the data in this recordset) but it those not bring in the actual values. The
field box is blank
work. I have setup a generic form to test this and have set up an unbound
field named child. I have set the form to continuous view and inserted this
code on open
Private Sub Form_Open(Cancel As Integer)
Dim test As String
test = "SELECT tbl00ProjectsHiearchyLevel2.Level2 AS Child FROM
tbl00ProjectsHiearchyLevel2"
Forms!tt.RecordSource = test
End Sub
When the form opens it correctly shows me the child field box 3 times (all
the data in this recordset) but it those not bring in the actual values. The
field box is blank