D
djf
I have a form with a combo box (A), a list box (B) and a datasheet view sub
form (C).
The user chooses a value in A, which brings up a list of corresponding
values in B. The user then chooses a value in B which brings up corresponding
values in C. Once the user is done looking at the records he starts the
process over by choosing a new value in A.
When the user chooses a new value in A, I want C to go back to its default
value of no records.
I have successfully done this on a different form where C is a list box
instead of a sub form. In the on change property for A I put in this code:
Me.lstActID_A.RowSource = ""
This resets the list box C back to no records.
Does anyone know how to reset the sub form back to no records?
form (C).
The user chooses a value in A, which brings up a list of corresponding
values in B. The user then chooses a value in B which brings up corresponding
values in C. Once the user is done looking at the records he starts the
process over by choosing a new value in A.
When the user chooses a new value in A, I want C to go back to its default
value of no records.
I have successfully done this on a different form where C is a list box
instead of a sub form. In the on change property for A I put in this code:
Me.lstActID_A.RowSource = ""
This resets the list box C back to no records.
Does anyone know how to reset the sub form back to no records?