View Full Version : Where Clause


elfranzen
02-12-2008, 11:41 AM
Where = "cardnumber = " & CardNumberGlobal

DoCmd.OpenForm "scoreform", acNormal, , Where, acFormAdd, acWindowNormal

When I do a Debug Print for where I get cardnumber = 1111111
The card number is a string because it might have a letter in it
don't i need it to be cardnumber = "1111111"

if so how do I get the quotes around the numbers

KeithG
02-12-2008, 11:46 AM
Where = "cardnumber = '" & CardNumberGlobal & "'"