text box control source

[mkelly]

Is it possible to run two commands in a text box control source?

If so how do you split them?

I want the first control to limit data based on a type
and the second function to calculate data

 

[Mile-O]

No, you are best to write a small function and call that in the ControlSource.

 

[mkelly]

ok now to sound totally dumb, how do I do that?

 

[Mile-O]

Well, that depends on what you want to do - what's the calculation you want in the ControlSource, what's the validation, and what's to be returned if the result goes outwith the required values?

 

[mkelly]

First I want it to look for all jobs that are dup-1

=Iif[work type]="dup-1"

Then I want it to run this calculation on the dup-1 records

=Int(Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time]))))*24+DatePart("h",Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time])))) & Format(Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time]))),":nn")