Automatically Clear Field In Table From Form 1

[RKAccess]

Hi All,

I have a Form with several fields and controls.

One of the controls is an Option Group that is linked to a field in Table "Main".

There is also a Combo Box that is linked to a different field in Table "Main".

For simplicity, I'll refer to the Option Group Field in Table "Main" as "Field1" and the Combo Box Field in Table
"Main" as "Field2".

The Option Group has 3 Check Boxes on it. If the Option 3 Check Box is selected the Combo Box becomes
Visible and I choose one of the preset values in it.

This in turn updates "Field1" in Table "Main" with Option 3
and "Field2" with the value I selected in the Forms Combo Box.

Now, here's where I need help... PLEASE...

If at a later date I select the particular record that I
have previously set to Option 3 and change it to Option 1
or 2, I would like the value in "Field2" of Table "Main"
to be automatically cleared.

Please note...
I not referring to just clearing the value on the Form, but
also clearing the value in the cell on Table "Main" for "Field2"
Also, I don't want to delete the entire row within the table, but merely clear the "Field2" value for the record I am on.

Any help would be appreciated...

 

[Francescina]

If the field's content is a string you could simply set its value to an empty string like:

me!FieldName=""