R
Richard
Hi
I have an enrolment form with a few combos and a subform. The user will
need to choose a name from a combo and click on a cmdbutton(insertcode) to
insert the name to a table (enrolmentid/participantid). If successful the
name will appear on the subform for show only.
It works fine on my pc with numerous tries without problems.
Sometimes(only sometimes), when the users (mde file) click on the cmdbutton,
an error appears,"more than one user is trying to update the record or
something like it (sorry for not being specific, forgot what it worte), and
only one user is using the database; the word 'error' will appear on the
fields of the form and the name is not inserted into the table. But the main
form record is saved.
I have gone through the code step by step but still can't locate the
problem. The form has 2 cmb querying the same table (could this be the
problem?)
Sorry for the long thread, and I hope you understand where I'm going here.
Thanks in advance
Richard
--
I have an enrolment form with a few combos and a subform. The user will
need to choose a name from a combo and click on a cmdbutton(insertcode) to
insert the name to a table (enrolmentid/participantid). If successful the
name will appear on the subform for show only.
It works fine on my pc with numerous tries without problems.
Sometimes(only sometimes), when the users (mde file) click on the cmdbutton,
an error appears,"more than one user is trying to update the record or
something like it (sorry for not being specific, forgot what it worte), and
only one user is using the database; the word 'error' will appear on the
fields of the form and the name is not inserted into the table. But the main
form record is saved.
I have gone through the code step by step but still can't locate the
problem. The form has 2 cmb querying the same table (could this be the
problem?)
Sorry for the long thread, and I hope you understand where I'm going here.
Thanks in advance
Richard
--