recordset Runtime Error 3075

[DMT Dave]

Hi guy's, can anyone put me right on this one please ? probably can't see the wood for the trees!!

Dim MyZero As Long, MySort As Long, MySort2 As Long



If Me.cboOptionsIndex6 = "Check Zero Qty" Then
MyZero = "0"
MySort = "1"
MySort2 = "10"
Set rs = CurrentDb.OpenRecordset("Select * From tblStock WHERE StartQty = " & MyZero & " And SortNo Between " & MySort & " And " & MySort2 & " & Order By SortNo;")

[CJ_London]

always helps to provide the error description, most people don't remember what they are for the 10k+ possible errors and may not want to spend time looking it up. Plus some error codes can have different descriptions depending on context.

May or may not be the problem but since your variables are dimmed as longs, you don't assign them string values - drop the double quotes. MyZero = "0" should be MyZero = 0

Beyond that, depends on the error description to tell you what to look at. Not prepared to speculate or spend time looking it up

[ranman256]

Don't use strings where you want numbers.