lemon_balm
Registered User.
- Local time
- Today, 02:20
- Joined
- Feb 7, 2006
- Messages
- 65
Hi
I am trying to pass some details from a combo box into an email I am creating as part of a call logging system for my company.
I want to pass the text relating to the combo and not the actual bound column so I thought that an IF statement would be the way to go.
I have used message boxes to generate stop gap answers whilst running the code at testing stages (to stop my inbox getting too clogged up) and however I write the IF statement, I get the answer "Wrong"
Code:
If "Me!CallIssue" = "tables!tblissues.issueid" Then
MsgBox ("Correct")
'Issue = "tables!tblissues.Issue" <-----It won't pass this field
Else
MsgBox "Wrong"
'Issue = Me!CallIssue <-----Always passes the value from this field
End If
CallIssue is the join for issueid in tblissues. They are noth in number format.
Issue is a string variable
Has anyone got any ideas as I can pass the ID number for the field but not the text which is what I require
Regards
Jason
I am trying to pass some details from a combo box into an email I am creating as part of a call logging system for my company.
I want to pass the text relating to the combo and not the actual bound column so I thought that an IF statement would be the way to go.
I have used message boxes to generate stop gap answers whilst running the code at testing stages (to stop my inbox getting too clogged up) and however I write the IF statement, I get the answer "Wrong"
Code:
If "Me!CallIssue" = "tables!tblissues.issueid" Then
MsgBox ("Correct")
'Issue = "tables!tblissues.Issue" <-----It won't pass this field
Else
MsgBox "Wrong"
'Issue = Me!CallIssue <-----Always passes the value from this field
End If
CallIssue is the join for issueid in tblissues. They are noth in number format.
Issue is a string variable
Has anyone got any ideas as I can pass the ID number for the field but not the text which is what I require
Regards
Jason