access vba string that references multiple numeric items in a form

Question

So I am writing a string in VBA. It needs to use 2 different numeric variables from a form that the user clicked on. My code works great if I only use 1 variable, but I can't get the syntax correct for 2 variables. Here is what I originally wrote that works fine.

stringSQL = "select table1.field1, table2.field2 from table1 where table1.flag='flag' and 
table1.weight = " & [Forms]![myform]![weight]

When I try to add age to the string (I want to use age and weight from myform) I write this which does not work -

stringSQL = "select table1.field1, table2.field2 from table1 where table1.flag='flag' and 
table1.age= " & [Forms]![myform]![age] & " and " & table1.weight= " & 
[Forms]![myform]![weight]

Tim Williams · Accepted Answer · 2014-06-09 04:16:42Z

1

stringSQL = "select table1.field1, table2.field2 " & _
            " from table1 where table1.flag='flag' " & _
            " and table1.age= " & [Forms]![myform]![age] & _
            " and table1.weight= " & [Forms]![myform]![weight]

edited Jun 9, 2014 at 4:16

answered Jun 7, 2014 at 3:31

Tim Williams

169k8 gold badges104 silver badges144 bronze badges

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

2 Comments

joeumlo Over a year ago

ahh thanks a million, i've been stuck on this problem for hours! I thought the & symbol meant concatenate, why is it that mine is incorrect and your works?

Tim Williams Over a year ago

In your example you have table1.weight outside of the literal string part of the expression.

Collectives™ on Stack Overflow

access vba string that references multiple numeric items in a form

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related