hello... I have two comboboxes... cboChoiceName is based on a query... when you select an item it populates cboChoiceSys. When you make a selection it populates lboEntitlements. My problem is when I change a selection in cboChoiceName, cboChoiceSys goes back to (0) and I can make a selection. However, the listbox retains the information from the previous selection until I make a selection in cboChoiceSys... any suggestions...
Option Compare Database
Private Sub cboChoiceName_AfterUpdate()
Me.cboChoiceSys = Null
Me.cboChoiceSys.Requery
End Sub
Private Sub cboChoiceSys_AfterUpdate()
Me.lboEntitlements = Null
Me.lboEntitlements.Requery
End Sub
Option Compare Database
Private Sub cboChoiceName_AfterUpdate()
Me.cboChoiceSys = Null
Me.cboChoiceSys.Requery
End Sub
Private Sub cboChoiceSys_AfterUpdate()
Me.lboEntitlements = Null
Me.lboEntitlements.Requery
End Sub