[AccessD] Find Record from Combo

Hollis,Virginia HollisVJ at pgdp.usec.com
Tue Apr 6 06:18:42 CDT 2004


I have a combo box that is used to GoTo a record. When I first open the
form, I have noticed that the list of choices in the combo box do not show
all the records to go to - it stops at record 9 and there are 57. I can't
scroll any further down the list either it only shows 9 records.

If I go to the last record and come back to record 1, then the combobox list
will show all 57 records. I even tried typing in 57 to go to the record, and
it says it is not in the list.

It is so strange, if I go to record 9 the list shows 9 records, I navigate
to record 10, the list shows 10 records, etc.

A2K.

Virginia

Used on the ComboBox.
Private Sub PickRequest_AfterUpdate()

 Dim strNumber As String
    ' Find the record that matches the control.
    strNumber = "[tbl_RequestMain].[RequestID] = " & Me![PickRequest]
    Me.RecordsetClone.FindFirst strNumber
    Me.Bookmark = Me.RecordsetClone.Bookmark

End Sub



More information about the AccessD mailing list