Just wondering what's wrong with this coding
UN = Form_MAIN!LOGIN_DETAILS.Value
model = Form!COMBO_MODEL.Value
stDocName = "MODEL_SELECTION"
stCOND= "[MODEL_LN]='" & model & "'" And "[TM_NAME]='" & UN & "'"
DoCmd.OpenReport stDocName, acViewPreview, , stCOND
I'm getting a type mismatch error on the line where I specify value to stCOND.
If I run 2 conditions seperately one by one they run fine but when I join them using AND I get an error