I'm not sure if i'm being clear. The form initially is unbound, and when i
double-click on a control on another form this unbound form opens and runs a
select command as recordsource based on the value that was on the control
that was double-clicked. Ok, so far. Then i need to allow the users to update
some information contained on the form. And the problem is here. On this form
i have 2 fields, one with parcial amounts and one with total amounts, all for
the same item. On the parcial amounts control i have an after update event
that sums all the parcial amounts of the item in question to check if the sum
is less or equal to the amount. What i found out is that when i update the
parcial amount and the event triggers, i create a recordset to perform this
verification and the table in question still contains the old value. That is
why i put an SQL Update command before this verification. That was a solution
that solved the problem but triggers me the Write confilct message.