I have a form (frmTaxPayerDialog) which has a parent plus 7 subforms. The issue is the client wants one of the parent controls moved to one of the subforms but still filter the data on the parent using the moved control. The parent and the subforms have a field (lngTaxpayerID) in common. The field moved was the userid. The userid needs to be part of the project subform (tblprojects) verses the main taxpayer form (tbltaxpayer). Originally the userid (database user) was assigned based on the taxpayer but now several user working on different projects need access to the taxpayer. My question is if changing the parent form data source from the tbltaxpayer to a query which links the data from the tblproject (userid field) to the tbltaxpayer still update the fields in the tbltaxpayer when moving to a different record on the form. The userid will not be listed on the parent form only on the projects form.
The main reason is to limit the user to those taxpayers associated with the user's projects. Multiple users may be process taxpayers for a given project.
Hope I presented the issue clearly. Using Win 7 & 8.1 with Access 2010.
Rod
Posted by: desertscroller@cox.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar