Look up combo box on main form puzzling

JimJones

Registered User.
Local time
Today, 11:47
Joined
May 6, 2003
Messages
78
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
 
Sorry folks,
I think I messed up when creating the new form, and somehow
didn't tell it which table to link it to.

BUT, please stand by as I may have some other questions regarding this service database.

Thanks,
Jim
 
What version of Access are you using? If it's 2000+, do you know if you're using ADO or DAO?
 
Hello.

I'm using Windows 2K, and Office 2K, with SP-3.

I don't know if I'm using ADO, DAO, and would appreciate knowing a little more about that.

Thanks,
Jim
 

Users who are viewing this thread

Back
Top Bottom