Parameter value being asked for

[Guest]

I am defining the recordsource in the open event of a new form as follows:

Me.RecordSource = "Select [tbl_History].* From [tbl_History] " & _
"Where [HistAccountNo] = 1 And [HistLastname] = Smith"

When I open this form I get an "Enter Parameter Value" box looking for a
value for "Smith". Why is this happening?

ctdak

 

[Allen Browne]

Presumably HistLastname is a Text type field, so you need quotes around the
literal value:

Me.RecordSource = "Select [tbl_History].* From [tbl_History] " & _
"Where ([HistAccountNo] = 1) And ([HistLastname] = ""Smith"");"

If those quotes don't make sense, see:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html

 

[Guest]

Thanks again. I knew I had run into this before but couldn't remember when
or what the solution was.
ctdak

Presumably HistLastname is a Text type field, so you need quotes around the
literal value:

Me.RecordSource = "Select [tbl_History].* From [tbl_History] " & _
"Where ([HistAccountNo] = 1) And ([HistLastname] = ""Smith"");"

If those quotes don't make sense, see:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am defining the recordsource in the open event of a new form as follows:

Me.RecordSource = "Select [tbl_History].* From [tbl_History] " & _
"Where [HistAccountNo] = 1 And [HistLastname] = Smith"

When I open this form I get an "Enter Parameter Value" box looking for a
value for "Smith". Why is this happening?