forms_are_nightmares
Registered User.
- Local time
- Today, 09:32
- Joined
- Apr 5, 2010
- Messages
- 71
Hello All,
I can not figure out why I'm getting a Type Mismatch error with the following code. Any help/insight is appreciated.
If Condition then
Val = ("Cmgr = '" & Me.[CMgr_cmbo] & "'") And ("Aname = '" & Me.AccountCmbo & "'")
Else
Do Something Else
End If
Val is a string
Cmgr, Cmgr_cmbo, Aname, Accountcmbo are all text fields.
Essentially, the form will filter based on the values a user enters.
I can not figure out why I'm getting a Type Mismatch error with the following code. Any help/insight is appreciated.
If Condition then
Val = ("Cmgr = '" & Me.[CMgr_cmbo] & "'") And ("Aname = '" & Me.AccountCmbo & "'")
Else
Do Something Else
End If
Val is a string
Cmgr, Cmgr_cmbo, Aname, Accountcmbo are all text fields.
Essentially, the form will filter based on the values a user enters.