N
ndunwoodie
I'm looking in a table for a particular name (the one in a combo box on a
form) that has today's date. I used the following code, but I'm getting a
type mismatch. I was not surprised because I was guessing at the code.
If DLookup("txtName", "tblSilTrans", "txtName = " & Chr$(39) & cboName &
Chr$(39) And "datDate = " & Chr$(39) & Date & Chr$(39)) Then
Can someone correct this? Thanks.
Nick
form) that has today's date. I used the following code, but I'm getting a
type mismatch. I was not surprised because I was guessing at the code.
If DLookup("txtName", "tblSilTrans", "txtName = " & Chr$(39) & cboName &
Chr$(39) And "datDate = " & Chr$(39) & Date & Chr$(39)) Then
Can someone correct this? Thanks.
Nick