Help needed with action query in macro.

[jfaz]

I really need some help with this.

I have created a form which users complete to book holidays. A macro is
then run which firstly runs an append query to a main table and then another
action query to delete record on the input form and refresh the data on the
underlying table. I have done it this way so that users cannont change data
on the main form once entered.

During testing it became clear that if more than one user was to be
inputting into this form when the first person has run the macro it updates
for anything in the input table. This results in an error message being
displayed to the second user that their record cannot be updated due to key
violation errors, although the record has already been posted. I feel this
will confuse users (particularly as they are not confident i.t. users)

Is there a way that I can restrict the update macro to only post to the main
table the record that particular user has input?

 

[Steve Schapel]

JFaz,

First of all, what you are doing is probably unnecessarily complicated.
Probably if you bind your form directly to the main table, you can
simply set the Allow Edits property of the from to No in order to
prevent changes to previously entered records.

Now, in order to understand the problem you are experiencing, can you
tell us:
- does each user have their own individual copy of a frontend
application file which includes the forms?
- is the table you are using for the temporary holding of the inputted
data, in the backend data file or the frontend application file?
- what are the details of the macro exactly, and the details of the
Append and Delete queries?

Thanks.