J
Jack Sheet
Uff. Still having problems (Access 97)
I created a very simple form, that simply displays all of the fields in a
table, as text boxes with one exception which is a combo box. The idea is
to select a record from a drop-down list in the combo box, rather than using
the bar at the bottom of the form.
When I select a new record from the drop-down list I get the run time error
2105, and when I debug the row "Me.Bookmark...." is highlighted in yellow in
the following code. Any takers? Thanks.
Sub Combo50_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Ref] = '" & Me![Combo50] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
I created a very simple form, that simply displays all of the fields in a
table, as text boxes with one exception which is a combo box. The idea is
to select a record from a drop-down list in the combo box, rather than using
the bar at the bottom of the form.
When I select a new record from the drop-down list I get the run time error
2105, and when I debug the row "Me.Bookmark...." is highlighted in yellow in
the following code. Any takers? Thanks.
Sub Combo50_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Ref] = '" & Me![Combo50] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub