I have placed an unbound combo box in the form header for searching records.
The combo box properties are:
Name: cboID
Row Source: SELECT ID, Desc FROM Table1
Column Count: 2
Bound Column: 1
Limit to list: Yes
I have set the AfterUpdate event procedure:
with Me.RecordsetClone
.MoveFirst
.FindFirst "ID = " & Me!cboID
Me.Bookmark = .BookMark
End With
The form's record source is Table1. The combo box worked fine until now. No changes made to the form. I can only use the combo box once and after that the list drops down fine but an item on the list cannot be selected - the combo box locks up.
Please help.
I am using Access 2000.
The combo box properties are:
Name: cboID
Row Source: SELECT ID, Desc FROM Table1
Column Count: 2
Bound Column: 1
Limit to list: Yes
I have set the AfterUpdate event procedure:
with Me.RecordsetClone
.MoveFirst
.FindFirst "ID = " & Me!cboID
Me.Bookmark = .BookMark
End With
The form's record source is Table1. The combo box worked fine until now. No changes made to the form. I can only use the combo box once and after that the list drops down fine but an item on the list cannot be selected - the combo box locks up.
Please help.
I am using Access 2000.