Query Update Criteria Continuous Form Row ID

[andrebmsilva]

Hello everyone,

I have this doubt: What should i write in the criteria of a Query Update so that when I click on the Check-Box of the row, writes something in a field of the this row?
I've tried using the ID master and sub... but didn´t work. I've tried something like this Criteria: [Forms]![FormName]![rowID]. But so far i couldn't do it.
What am I missing? I don't understand... Hope someone can help me.



Thanks,
André

[June7]

Is the checkbox bound to field of form RecordSource? If it is unbound then the same value will show for all rows.

Is the continuous form a subform on another form?

Show the complete SQL statement of the query.

[andrebmsilva]

June7 my problem is solved, thank you!