If statement

[Guest]

I would like to write an If statement that will fill more than 2 text boxes.

I can do one at a time like this:
If A = >0 then B = "6"
If A = > 0 then C = "7"
If A = >0 then D = "8"
I would like to say
If A = >0 Then B = "6" And C = "7" And D = "8"

However I get an error
Is there a better way?

 

[Stefan Hoffmann]

hi,

I would like to write an If statement that will fill more than 2 text boxes.

I can do one at a time like this:
If A = >0 then B = "6"
If A = > 0 then C = "7"
If A = >0 then D = "8"
I would like to say
If A = >0 Then B = "6" And C = "7" And D = "8"

However I get an error
Is there a better way?

yup:

If A => 0 Then
B = "6"
C = "7"
D = "8"
End If


mfG
--> stefan <--

 

[Guest]

Thanks, that is what I wanted.

hi,

yup:

If A => 0 Then
B = "6"
C = "7"
D = "8"
End If


mfG
--> stefan <--

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[jahoobob via AccessMonster.com]

Good grief George! It appears as though your AUTO-REPLY has done so to a
number of thread in this group. Hope you can fix it so it doesn't do this
the next time you leave for a few days.
Bob