S
steve
I have a form with some sub forms using the "link child
fields" and "link master fields". the sub form is tabular
view and each record there is several text boxes and a
yes/no check box all linking back to the record source
table. On the sub form, I want the user to check or
uncheck some of the yes/no boxes, when the user checks
the cleared yes/no box I have the this code, which
requerys all of the queries on the main form
Private Sub Cleared_AfterUpdate()
Dim ctlBox As Control
' Return Control object pointing to contral box.
Set ctlBox = Forms!FRM_Rec_Recen!BankEB
' Requery source of data for contral box.
ctlBox.Requery
End Sub
Every thing works great, including all the requerys. But
on the subform, all the records before the record that
was selected disappear off of the sub form.
Why is this? how do I get the records to stay after the
requery event?
thanks
steve
ps using 97
fields" and "link master fields". the sub form is tabular
view and each record there is several text boxes and a
yes/no check box all linking back to the record source
table. On the sub form, I want the user to check or
uncheck some of the yes/no boxes, when the user checks
the cleared yes/no box I have the this code, which
requerys all of the queries on the main form
Private Sub Cleared_AfterUpdate()
Dim ctlBox As Control
' Return Control object pointing to contral box.
Set ctlBox = Forms!FRM_Rec_Recen!BankEB
' Requery source of data for contral box.
ctlBox.Requery
End Sub
Every thing works great, including all the requerys. But
on the subform, all the records before the record that
was selected disappear off of the sub form.
Why is this? how do I get the records to stay after the
requery event?
thanks
steve
ps using 97