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