If I want to do an OnLoad() event for a form that does a sql statement that just selects a set of records, how do I make the form a continuous form as I move through the recordset? Example
.open sql ....
rs.movefirst
do while not rs.eof
Me.text_name = rs("name"
rs.movenext
Loop
When I try to do this to an unbound form and unbound controls in the form, it just loops through the recordset and displays the last record value in a single form after completing the loop. I have the continuous form selection selected in the form properties.
Any ideas?
Thanks for the help.
.open sql ....
rs.movefirst
do while not rs.eof
Me.text_name = rs("name"
rs.movenext
Loop
When I try to do this to an unbound form and unbound controls in the form, it just loops through the recordset and displays the last record value in a single form after completing the loop. I have the continuous form selection selected in the form properties.
Any ideas?
Thanks for the help.
