Run-time error 2580 + other issues, including Access not recognizing the input i have set

[unixhd]

Hello,
I have been trying to fix this for ages now.


So, what I am trying to do here is to filter this subform using a drop-down menu (maybe an input field will be a better idea) and when I apply the filter I get this run-time error 2580. It says that the record source does not exist. I believe it is because Access does not recognize the input from the combo-box (drop-down) as an Int. But after chaning it to Int it did not work again.


The code :
Private Sub Combo502_AfterUpdate()Dim lenghty As String
lenghty = "select * from dbo_m4_bolts_subform where([m4_lenght]=" & Me.Combo502 & ")"
Me.dbo_m4_bolts_subform.Form.RecordSource = lenghty
Me.dbo_m4_bolts_subform.Form.Requery
End Sub

[Gicu]

Judging from the field alignment in your screen shot I'd say the field is set as (short) text in the table, not a number, so you need to wrap it in single quotes:

lenghty = "select * from dbo_m4_bolts_subform where [m4_lenght]='" & Me.Combo502 & "';" 'assumes the name of the table is dbo_m4_bolts_subform!!!!

Cheers,

[unixhd]

Thanks for the response Gicu, I just tried what you suggested but it did not work. It gave me the same error. I just noticed that when i receive this error there is a "#Name?" in the field of m4_thread, could that be the issue?

[unixhd]

I just got a response from someone and they helped me solve it by reminding me that when selecting which fields to be searched I should set the source as the main table not a subform table.

The answer :
lenghty = "select * from dbo_m4_bolts where([m4_lenght]=" & Me.Combo502 & ")"

[Gicu]

Hard to say just from a screen shot, maybe you can upload a small sample db (no sensitive data, just a couple "dummy" records to illustrate the issue). From the table prefix seems like you have a SQL server back-end, you could import just the table(s) needed by the form.

Have you tried to bind the form to a query in which you make reference to the combo and in the AfterUpdate to simply leave just the last line (the subform requery)?

Cheers,

[Gicu]

That was why I added the comment in my first post....
Glad to hear you go it working, good luck with your project!

[Welshgasman]

Do you really have a table called subform?

[Minty]

Do you really have a table called subform?

No - that's what the correction the OP made sorted out.

[Micron]

Just in case somewhere down the road (e.g. in code) if you start to type 'length' instead of 'lenght', you'll have some issues.

[Welshgasman]

The OP said he had a subform table?
I was trying to see if that table actually has the word subform in it?