[AccessD] RE: Find Record from Combo

I noticed I can't recreate a new combobox either in the current database or
any database. I keep receiving the error: Syntax Error in Query Expression.

I am using the Wizard to create the combo & select option 3 - find a record
based on...

I do not know if this is a related problem with only showing 9 records or a
separate problem. The existing combobox that shows only the 9 records, I
used the code from a previous form.

Virginia

-----Original Message-----
From: Hollis,Virginia 
Sent: Tuesday, April 06, 2004 6:19 AM
To: 'Access Developers discussion and problem solving'
Subject: Find Record from Combo


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