J
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?
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?