Why don't this query work?

[lawdy]

I hope someone will show me how to make this query work. I do have a table named tblCalendar with a field named pubLngProposalNo. There is a record in it containing proposal number 20250767 and a field named fTxtPrebill containing the value of yes. Below is my code.

Public Function modCal_Mine()


Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim sqlQuery As String

pubLngProposalNo = 20250767

Set db = CurrentDb
sqlQuery = "SELECT * FROM tblCalendar WHERE rs![fLngProposalNo] = " & pubLngProposalNo & " AND rs![fTxtPrebill] = 'yes'"
Set rs = db.OpenRecordset(sqlQuery)

Do While Not rs.EOF
Debug.Print rs!fLngProposalNo
rs.MoveNext
Loop

rs.Close
Set rs = Nothing
Set db = Nothing
End Function

Thank you in advance for your help

[lawdy]

I failed to mention that I get Run-Time error '3061': Too few parameters. Expected 1. Sorry about that.

[XeviBatlle]

The column names in the sql statement must reference to the names of the table, not the to the recordset, something like this:

sqlQuery = "SELECT * FROM tblCalendar WHERE [fLngProposalNo] = " & pubLngProposalNo & " AND [fTxtPrebill] = 'yes'"

'"

[isladogs]

Is ftxtprebill a Boolean (yes/no) field or a text field?

[Welshgasman]

No need for domain name in fieldnames, unless the fieldnames are duplicated between domains.

[CJ_London]

I would also clarify if proposal number 20250767 is text or numeric- this sort of value is usually stored as text since I wouldn’t expect any maths to be done on it and at some point could contain non numeric characters. As a number it had a small benefit of taking less space than the text equivalent

[lawdy]

Thank you XeviBatlle , It works now. Things are so simple when you know what you are doing.
islagogs, the
ftxtprebill is a text field
Welshgasman, thanjks for the additional info.
CJ_London, now I am wordering if I created proposal numbers, property numbers, and humpteen others wrong by making them
numeric instead of text. They are all numeric.
Again thanks to all.