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.
Private Sub LCNo_Click()
DoCmd.OpenForm "frmLetterOfCreditAdd", , , "[LCNo]=" & Me!LCNo