Checkbox Update query

[trebor3900]

I have a Mainform with a subform linked to a table.
Within the subform i have a number of individual checkboxes and a field [Year].
One checkbox, [checkboxIssue] i have wanted to link two update queries in order
to update the field[Year] with the contents of a [textboxValue] on the Mainform,
depending on the state of [checkboxIssue].
I have run both queries manually, one after the other and the table was updated perfectly.

The problem is that when i link it to the click_Event of [checkboxIssue]
in the subform i get zero updates.

Linked to the Dirty_Event of the subform i get good results for all except the last ammended
record and zero results if ammending only one record.

I am a relative Newbie and have learned a great deal from this forums expertise.
Can anyone enlighten me to what i think will be my very basic error.

Basic or not i have driven myself mad trying to solve it..:-(

 

[Haymarket]

I am having a little difficulty under standing what you are trying to do.

One checkbox, [checkboxIssue] i have wanted to link two update queries in order to update the field[Year] with the contents of a [textboxValue] on the Mainform, depending on the state of [checkboxIssue].

If you want to update one box with the contents of another then why not use a:

me.textbox = me.otherfield

What are the update queries doing?

 

[trebor3900]

Sorted but thanks for replying

I was trying to update a field in another table depending on the state of the checkbox in the subform with the value of the textbox on the Mainform.

I gave myself a slap on the head and included the field i needed to update in the subform and updated it as you said.

Thanks for your time anyway

 

[Haymarket]

Glad it was of help - I often sit there wondering why I can't do something for the same reasons.