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