Using value from one field to put a certain value in another field

[scopes456]

I have a table called tbl_Employess. The table is use to track a daily checklist. I have one field label " Check_Complete" which is a yes/no and another called "Resolution". I would like under "check_complete" when someone selects NO, it will automatically put "Turn over to other shift" in the Resolution field.

 

[pbaldy]

One way:

http://www.baldyweb.com/ConditionalVisibility.htm

 

[scopes456]

pbaldy thank you for the information. The only way i can do this is on the form itself. There is notting that can be coded on the table field itself?

 

[arnelgp]

if it is a checkbox control, code its on click event:

Private Sub yourCheckBoxControlName_Click()
Me.Resulution = Iif(Me.youCheckBoxControlName, "", "Turn over to other shift")
End Sub

replace youCheckBoxControlName with the correct name of your control.

 

[sneuberg]

Sound like your want the Resolution field to be a calculated field as described in

https://support.office.com/en-us/ar...-a-table-14a60733-2580-48c2-b402-6de54fafbde3

The expression might be something like

iif ( [Check_Complete], "", "Turn over to other shift" )

However, the Resolution field depends on the value of the Check_Complete field which violates normal form. So if you don't want to be a violator of normal form you should leave this out of the table and put it in queries as an expression.

 

[Cronk]

Scopes456: "The only way i can do this is on the form itself. There is notting that can be coded on the table field itself?"

No, not in MS Access. Look to other dbase engines if you want this functionality.

 

[smig]

If resolution field is calculated one you should not save it on the table. Recalculate when need.

 

[scopes456]

all, thank you for your help, i will not store it on the table, and recalculate when needed.