string vs numeric fields in a query

Question

I'm getting an error 3061, too few parameters on this:

Dim PrbApps1 As Recordset

Set PrbApps1 = CurrentDb.OpenRecordset("Select * FROM [Application] WHERE [PYR_TenderRef] =" & TenderID.Value)

where TenderID is a textbox

I'm new to this, but I've check everything I can think of. Probably simple error but any help would be greatly appreciated.

Grant · Accepted Answer · 2013-08-01 13:04:17Z

1

You need double quotes on the other side of your textbox value. But if it's in an access form it should be referenced with Me.

Set PrbApps1 = CurrentDb.OpenRecordset("Select * FROM [Application] WHERE [PYR_TenderRef] = '" & Me!TenderID.Value & "'")

edited Aug 1, 2013 at 13:04

answered Aug 1, 2013 at 12:07

Grant

9031 gold badge17 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

eoinone Over a year ago

Thanks, it actually needed ' as well = '" & Me.TenderID.Value & "'") why I don't know.

Elias Over a year ago

FYI, use me! instead me. me. references the textbox as a property of the me object. me! creates the textbox as an object, which execute a little faster when you have a lot of references. (Though intellisense doesn't work with it sadly)

Grant Over a year ago

I had no idea, I thought it was just preference. Thanks @Elias

Elias Over a year ago

Here goes some explanations: msdn.microsoft.com/en-us/library/office/…

Collectives™ on Stack Overflow

string vs numeric fields in a query

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related