Runtime error 2001 - huge frustration

[Widge]

I've been using code similar to this:

 
Option Compare Database
 
Private Sub Form_Open(Cancel As Integer)
 
    SetFilter
 
End Sub
 
Sub SetFilter()
 
    Dim LSQL  As String
    Me.Refresh
    LSQL = "SELECT * FROM AccountCardRegister, AccountCardComments"
    LSQL = LSQL & " WHERE AccountCardRegister.AccountCard = '" & Combo128 & "'"
 
    Debug.Print LSQL
    Form_Maintain_CardDetails.RecordSource = LSQL
 
End Sub
 
 
Private Sub Combo128_AfterUpdate()
 
 
    SetFilter
 
End Sub
 
 

throughout my DB. It works on all my forms apart from the one I have detailed above. I can't figure out why.

Basically, you select a record using the combo box and all the text boxes I have on the screen populate for that record, including a subform which is a single textbox. Its not getting past the initial openform though!

The status bar details "This recordset is not updatable" when I try to go into the form. No other form does this. Can anyone else?

The full error message is "You cancelled the previous operation".

I've stepped through a few times and its the WHERE clause that is causing the most grief. If I just select *, it all runs through fine, but this doesn't let me whittle down my records by using the combo box.

Thanks!

[Widge]

Delete delete.... I've found it.

I was trying to select a number in 'xxxxxxxxx' where I should have been trying to select it without the ' ' .....

[MMcCarthy]

Delete delete.... I've found it.

I was trying to select a number in 'xxxxxxxxx' where I should have been trying to select it without the ' ' .....

Glad you figured it out. Hopefully someone searching the same problem will find your solution.

Mary

[Widge]

Thats what I thought, nothing worse than finding something you've been trying to do and then hitting a dead ended thread. This place has been a fantastic resource for me!

[MMcCarthy]

Thats what I thought, nothing worse than finding something you've been trying to do and then hitting a dead ended thread. This place has been a fantastic resource for me!

Glad to hear it.

[mforema]

Delete delete.... I've found it.

I was trying to select a number in 'xxxxxxxxx' where I should have been trying to select it without the ' ' .....

I have no idea what this means. I have a similar problem, and this doesn't help me. Can someone explain what this solution means?

Thanks!
~mforema

[mforema]

I have no idea what this means. I have a similar problem, and this doesn't help me. Can someone explain what this solution means?

Thanks!
~mforema

Haha, I just figured it out, too. Widge removed the single quotation marks around the combobox reference. I guess single quotation marks aren't used with numbers.

My code had something similar, where I reference a textbox that users type a number into. I removed the single quotation marks, and the code worked like a charm!

Thanks again!