Creating an unbound continuous form

[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

 

[Robert Morley]

Looks good as is, I think. You might want to try using "Me" instead of
"Forms!tt". You can also try requerying, and finally, if the above fails,
have a look at the name of your field vs. the name of the control. By
default, Access names them both the same, and sometimes confuses itself in
the process. I try to make a habit of naming my controls differently from
my fields, just to be safe.

You may want to also try using a different name than "Child"...I don't
*think* it's a keyword, but it might be.



Rob

 

[Bruce M. Thompson]

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

As you have found, an unbound continuous form is not viable.