Text Boxes and Combo Boxes

[GendoPose]

Hi all,

I have 4 text boxes that are serving as calculated fields on my form, and these are based off certain values in certain boxes, i.e the run rate and the quantity in a certain production department, so for example, the run rate is 5000, the production department is machine so the text boxes works out the time elapsed based on the machine quantity, same for bench, etc.

What I now need is to hide these 4 fields and have a single text box then basically says "If Production Department is MACHINE then show the result from MACHINE CALCULATION and If Production Department is BENCH then show, etc etc". I've tried several different pieces of code but all I'm getting is a blank text box.

Any ideas?

Thanks!

 

[pr2-eugin]

Could you show us what you have been working with? So we could offer recommended changes?

 

[GendoPose]

Yeah if you give me a few minutes, I'll upload a stripped down version

 

[GendoPose]

Here, it's very stripped down with only 2 records, as I can't really give information away about my company.


In the planner query form, you can enter in the total qty, machine, bench, etc and choose the production department, and the run rate. the calculated boxes work out how long it takes depending on which qty field has been entered in and the run rate. I'd like the HOURS box to choose the right calculated field based on what's chosen in the production department combo box.


Thanks

 

[GendoPose]

Ok I think I've got it now! I ended up using the If Me.Combo1.Column(1) = etc, code and it worked fine, so thanks for at least having a look!