Hi all
Im using a simple update query on a command button.
It just updates a field "A" in the relevant table, to a combination of 3 fields with "&" joining them, no problem here..
This works perfectly except for the current record or rather last record which Ive just added in the form! This field "A" remains blank until I exit the DB and return then run the query again at which point it populates it correctly..
Ideally I want the query to update just the latest record... does anyone have a solution as to how to 'build' the 'criteria' (I assume the criteria is the best method?) or at least have a solution to update the active record??
Thanks