CoolFactor
Technical User
Hello,
I have couple list boxes on a form that depend on each other . In list box 1 I have the following VBA code in the Before Update Event:
Private Sub ListBox1_BeforeUpdate(Cancel As Integer)
Me!ListBox2.Requery
End Sub
When I select an item in list box 1 then list box 2 shows the relevant information for that item selected in list box 1. I know how to clear the selections when any item is selected in list box 1 but what I really need is how to undo the Before Update Event using a command button so that list box 2 shows nothing because I haven't selected anything from list box 1.
Thank you,
Anthony
I have couple list boxes on a form that depend on each other . In list box 1 I have the following VBA code in the Before Update Event:
Private Sub ListBox1_BeforeUpdate(Cancel As Integer)
Me!ListBox2.Requery
End Sub
When I select an item in list box 1 then list box 2 shows the relevant information for that item selected in list box 1. I know how to clear the selections when any item is selected in list box 1 but what I really need is how to undo the Before Update Event using a command button so that list box 2 shows nothing because I haven't selected anything from list box 1.
Thank you,
Anthony