Wednesday, August 02, 2006

MS Access Select List will actually update data

PROBLEM: Select List will change the value if set Control Source on Properties, or it will add a empty selection on the select list.
ANSWER:
1. Don't set anything on Control Source on Select List's properties.
2.
Private Sub Form_Load()
Me.Combo0.Requery
Me.Combo0 = Me.Combo0.ItemData(0)
End Sub

No comments:

Post a Comment