HELP: Validating a field using another checkbox field (1 Viewer)

[godofsix]

Hi,
Pls i have a database am working on in access 2010. I want a field to take its value based on another field's combo.

Example;
i have a checkbox field called "Loan" "Yes/No" and i have another textbox filed "Status" (which will hold eligibility). I want the Status to read Eligible when the checkbox is No and Non-eligible when its Yes

Thanks

 

[boblarson]

You should not be storing that status. It should be calculated at run time. So, remove that field from your table.

You then would use a query when you needed the status and you can create the calcuated field by using

MyNewNameHere:IIf([Loan]= True, "Eligible", "Non-eligible")

 

[godofsix]

You should not be storing that status. It should be calculated at run time. So, remove that field from your table.

You then would use a query when you needed the status and you can create the calcuated field by using

MyNewNameHere:IIf([Loan]= True, "Eligible", "Non-eligible")

Thanks so much it worked perfectly!!!

 

[godofsix]

The forum is very useful and i appreciate you guys for the help and also the founders of this forum.