Problem with output depending no If function

[AndyE]

The following code is my attempt at trying to obtain an output depending on a couple of factors...which are fairly easy to see from the code below. However it is not working!!

I'm sure for someone who knows what they are looking at it will be easy to resolve but I can't see the wood for the trees...

What I'm looking for is as follows...

Stream 1...

If the value of CBLink = no

then the output will be "A" if TBFurtherdets is empty, or
"B" if it contains text.

Stream 2...

If the value of CBLink = yes

then the output will be "B" if TBFurtherdets is empty, or
"D" if it contains text.

At the moment the code is running straight through and doubling up the output, which in my mind means I need to stop it somewhere when the desired response is identified, but I've tried moving things around etc. and I'm stumped.

Also, apologies if the code is crap, i've cobbled this together...

Please Login or Register  to view this content.

[tehneXus]

Hi

I'd do this without the jumping to option1 and option2 (untested as no sample data provided):

Please Login or Register  to view this content.

If for some reason you WANT or HAVE TO stick to the jumping skip option2 at the end of option1:

Please Login or Register  to view this content.

Please check the if statements in:

Please Login or Register  to view this content.

as

Please Login or Register  to view this content.

makes no sense, TBFurtherdets MUST be <> vbNullstring in that line.

Regards

[AndyE]

I see what should be happening but it still not working. The same is happening as was originally. That is why I thought it may be better to introduce the points to jump to.....................?

[tehneXus]

Hi,

Please Login or Register  to view this content.

could you provide example data?

Regards

[AndyE]

I have attached a mockup with the code for the commandbutton removed.

[tehneXus]

Hi,

the following controls used in the code do not exist, at least do not have the name used:
1. LBReport
2. TBFurtherdets
3. CBLink

Variables not declared:
1. strLinked

Variables used to fill another variable, but are empty all code long:
1. strLinked

What do you want to do with:

Please Login or Register  to view this content.

?

Please make sure you uploaded the correct file.

Regards

[AndyE]

Hopefully this should be it with the code substituted.

What I'm after is the equivalent of the result of clicking the commandbutton1 and the resulting data being dumpted into cell b2 for example.

It is the method of causing one output rather than the other that I'm interested in.....

[tehneXus]

Hi,

I found the following: The values which can be selected in the Combobox are "Yes" and "No" but you are checking for "yes" and "no". As the comparison is case sensitive both checks will result in FALSE, use this instead:

Please Login or Register  to view this content.

Another thing is writing the result into the worksheet, if you need help there just inform me.

Regards

[AndyE]

Its writing the result into the worksheet I am having trouble with. I'm aware of the case sensitivity bit.