Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select Query Correct Format. 1

Status
Not open for further replies.
bsupport

bsupport

Programmer
Dec 20, 2000
53
US
How do you write a Select query statement in the Microsoft Access Visual Basic Editor screen using a variable in the where clause?
Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset("Select * FROM tblProposalProducts " _
& "WHERE lngProposalID = " & Me.lngProposalID)

I get an error message stating "Syntax Error (missing operator) in query expression 'lngProposalID'."

Can anyone help. Thanks!
 
Sort by date Sort by votes
Change the Dot . after ME to a Bang !

Me!lngProposalID

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
354
monkeysee
monkeysee
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
2K
lameid
lameid
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
539
Swi
Swi
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
2K
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
664
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top