emailing a form

[emitecaps]

Hi,
I have a form that contains order entry items. When a user records the order details they hit a button which sends a confirmation email to the client showing, in the message body, what they have ordered...
Is there a way of only including those fields from the form where the value is greater than zero?
We have many products on our database and it would be easier for the client if they could only view the products they've ordered and also their quanitity.

thanks
Barry

 

[gol4]

Yes you can easily only include those fields from the form where the value is greater than zero?
The solution however is based on the code that mails this form. How is it being done now

 

[emitecaps]

I'm using the following:-

Dim strTo As String, strSubject As String, strMessage As String

strTo = Me.Email
strSubject = "Download Report
strMessage =


I have a field called JobDescription and one called PersonSpec. If there are no downloads of PersonSpec and one download of JobDescription I'ld like the body of the text to read as follows:

"Job Description 1"
...there would be no mention of PersonSpec

thanks
B

 

[PHV]

And the problem is ?
Have a look at the If instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[emitecaps]

well, it's that i'm not sure how to do it!

I can do this if there is just one category...say for the "equal opportunities" box...

If Me.Equal_Opportunities > 0 Then
strMessage = "Equal Opportunities = " & Me.Equal_Opportunities
ElseIf Me.Equal_Opportunities = 0 Then
strMessage = " "
Else
strMessage = " "

but I'm not sure how to add the extra categories...such as "job description"

thanks
Barry