Update query not working

[ADixon]

Hello all

I have a problem with an otherwise ok update query.

What i need to do is to track changes to a value in a textbox and then
update a secondary table with the value in the textbox. The 'textbox' is on a
continuous form which is in datasheet view. I know the string values i'm
using are being changed, so all i need to do is to use these values in an
update query.
All seems to be working when stepping through the code, but the value
doesn't appear in the table. I don't get any errors when warnings are off and
the table isn't read only.
(using A2003, table is a linked table from DFS)
Can anyone think of a reason why the values aren't appearing as they should
Thanks

 

[Michel Walsh]

If another user (running code is another user, at least, a different one
than the one doing modifications using the keyboard) save modifications to
existing records, you need a Me.Refresh to get those modifs. Note that
Me.Refresh WON'T allow your to see NEW records added by others, just the
modifications done to records your form is already aware of their existence.
You need a Me.Requery to get new records added by others (but that destroy
bookmarks and reset the form at the first record of the new set of records).



Hoping it may help,
Vanderghast, Access MVP

 

[ADixon]

Thanks for the reply Michel, but i think i must have explained the problem
badly. The issue was more about adding the changed value to a table. The
problem is solved anyway, but i'm not sure how i've managed it, so i can't
enlighten anyone else. Sorry.