I completed my first combo box that uses a select statement from my query. I was able to overcome my runtime error problem when there was a single quote in my "project". I was also able to get something other than spaces in my initial display when loading the form. It works great.



I click on the drop down and can look at all the "projects" and select the one I want to view and all the data associated with it appears on my form, (and subform).

Now, after I've selected my desired project, how do I get the next project to display if I page forward.

Everything else on the screen displays fine when I page forward and backward but the "project" I selected never changes.

My code is below.

Any help is appreciated.

Neil

My Row Source Type = Table/Query
My Row Source = SELECT qryCustomer.Project FROM qryCustomer ORDER by qryCustomer.Project;


Private Sub Combo257_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ProjectID] = " & Chr(34) & Me![Combo257] & Chr(34)
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Private Sub Form_Load()
Me!Combo257 = Me!Combo257.Column(0, 0)
End Sub