hi, im using access 2010. My db is split into a FE and BE. BE is on a share network drive. FE is located in multiple users home directories. All working ok except for a newley discovered issue.
i have a continuous form linked to a table. on the continuous form is a checkbox, bound to the table, therefore every record displayed on the form has a check box where the user can select. When multiple records are selected, the user can then select to carry out certain functions which uses the selected records, e.g. print report for each selected record.
the issue im having is when a second user opens their copy of the FE and selects their own records. because each user is selecting the tick box which is bound to the same table, then a user will print their records and the other records that were selected by the other user.
does anyone have any design ideas how i can code out this issue?? open to any suggestions.