Warning message

[jokobe]

hi ng,

I'm working within a form in ACC2000. The user can select
a value from a combobox and when changing the value via
combobox, two tables are updated via VBA
(actually functions are called for update). Now the
problem:
everytime after changing the value with the combobox, an
popup occurs:
This recordset has been changed by someone else, do you
want to save your changes or discard or save...
although I'm the only one working on the database.

any helpful hint?

thanks in advance

jokobe

 

[Ken Snell]

Sounds as if the table(s) being updated is (are) the same ones that your
form is using in its Recordsource. So the other user is "you". Are you
positive that you cannot use the form (through bound controls) to do the
updating instead of running VBA functions?

 

[jokobe]

Hi Ken,

that's a pretty fast answer. Thank You. Guess You are
right, but I'm not sure how to implement your solultion.
Actually one field in the in the form has to be updated,
the form is based on a query joining two tables. In
each table a field is updated.

joachim

 

[jokobe]

hi Ken,

I have solved the problem, it was fairly easy. Guess I had
a twisted brain for some time and couldn't see the easy
way to, well not to paradise, but to solve the prob.

thanks again

joachim

 

[Ken Snell]

Glad to hear it.
--

Ken Snell
<MS ACCESS MVP>

hi Ken,

I have solved the problem, it was fairly easy. Guess I had
a twisted brain for some time and couldn't see the easy
way to, well not to paradise, but to solve the prob.

thanks again

joachim