checkbox value

[Agrilima]

hello,



can someone help me,
Check my attachment

i want "OEE" check by itself without manuel check,

Value of "stopstand mainline" = J or N
if its J the checkbox has to be marked if N it has to be empty



Does anyone can help me what code i have to use... i try-ed multiple things but wont work


Greetz Nicky.

[ranman256]

put code in the AFTERUPDATE event

sub txtMainline_afterupdate()
  chkBox.value = ucase(txtMainline) = "J"
end sub

[Gicu]

I don't think you need the field OEE in the table if it is as easy, you just calculate it in a query as needed:

OEE:IIF([stopstand mainline]="J",True,False).

This will leave it unchecked for everything other than J as you did not mention if there are any other options or what to to if [stopstand mainline] is empty.

Cheers,

[Agrilima]

I don't think you need the field OEE in the table if it is as easy, you just calculate it in a query as needed:

OEE:IIF([stopstand mainline]="J",True,False).

This will leave it unchecked for everything other than J as you did not mention if there are any other options or what to to if [stopstand mainline] is empty.

Cheers

oh damn ur good haha thank u worked

[Gicu]