Open form, text data type
Experts,
I am trying to open a form to the criteria below.
The [LCNo] is text data type.
I believe I need some combination of single quotes and double quotes as it is text data type and not a number but the order and placement of the quotes is what I need help with.
thank you
Private Sub LCNo_Click()
DoCmd.OpenForm "frmLetterOfCreditAdd", , , "[LCNo]=" & Me!LCNo
End Sub
I am trying to open a form to the criteria below.
The [LCNo] is text data type.
I believe I need some combination of single quotes and double quotes as it is text data type and not a number but the order and placement of the quotes is what I need help with.
thank you
Private Sub LCNo_Click()
DoCmd.OpenForm "frmLetterOfCreditAdd", , , "[LCNo]=" & Me!LCNo
End Sub
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
DoCmd.OpenForm "frmLetterOfCreditAdd", , , "[LCNo]='" & Me!LCNo & "'"
exploded view
DoCmd.OpenForm "frmLetterOfCreditAdd", , , "[LCNo]= ' " & Me.LCNo & " ' "
or you can use this
DoCmd.OpenForm "frmLetterOfCreditAdd", , , "[LCNo]=" & chr(34) & Me.LCNo & chr(34)
exploded view
DoCmd.OpenForm "frmLetterOfCreditAdd", , , "[LCNo]= ' " & Me.LCNo & " ' "
or you can use this
DoCmd.OpenForm "frmLetterOfCreditAdd", , , "[LCNo]=" & chr(34) & Me.LCNo & chr(34)
ASKER
glad you came back quick because I scratching my head on that. thank you. it worked perfectly!
:-)
I'll blame my cellphone for that first post.
I'll blame my cellphone for that first post.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
"LCNo = '" &