Hi,
I have a database, which has a main or intro form.
When you click main, it goes to the main data entry/processing form.
I just put a subform on the main intro form, and a lookup combo box to go right to the customer record on the subform. but I get a debug. When I click on debug, it has a problem with the recordset statement.
Private Sub Combo133_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[CustomerNumber] = " & Str(Me![Combo133])
Me.Bookmark = rs.Bookmark (this one is hilighted)
End Sub
Can someone help?
Thanks,
Jim
I have a database, which has a main or intro form.
When you click main, it goes to the main data entry/processing form.
I just put a subform on the main intro form, and a lookup combo box to go right to the customer record on the subform. but I get a debug. When I click on debug, it has a problem with the recordset statement.
Private Sub Combo133_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[CustomerNumber] = " & Str(Me![Combo133])
Me.Bookmark = rs.Bookmark (this one is hilighted)
End Sub
Can someone help?
Thanks,
Jim