update query in form does not update table

  • Thread starter Thread starter SMatthew
  • Start date Start date
S

SMatthew

I am trying to use a macro which runs an update query in
a form. The problem I am facing is the update query and
the macro when run individually works fine. But in the
form, which runs this macro using a textbox's afterupdate
method does not update the record in the table the first
time. But when I change another data in the text box on
another record, this record does not get updated but the
previous updated record is updated in the table. Could
you tell me what I am doing wrong?
 
I am trying to use a macro which runs an update query in
a form. The problem I am facing is the update query and
the macro when run individually works fine. But in the
form, which runs this macro using a textbox's afterupdate
method does not update the record in the table the first
time. But when I change another data in the text box on
another record, this record does not get updated but the
previous updated record is updated in the table. Could
you tell me what I am doing wrong?
Click to expand...

Trying to update the same record in two different ways at the same
time. Once you open the record on the Form, Access assumes that you're
intending to edit it and locks the record so that no other process can
change it.
 
SMatthew,

Please see my reply in .macros newsgroup.

Just a hint for the future... If you really feel you want to post to
more than one newsgroup (in reality, this is seldom necessary), please
don't multi-post, i.e. send a separate message to both groups. It is
preferable to cross-post, i.e. address the same message simultaneously
to both groups. Thanks.

- Steve Schapel, Microsoft Access MVP
 
Back
Top