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