Hi Rod,
> "The userid will not be listed on the parent form only on the projects form"
just because the user doesn't want to see something doesn't mean it should not be there ... you can set the VISIBLE property to No for controls with key fields in them
The structure of your mainforms and subforms should be patterned after the relationships in your data
Tip: Enforce Referential Integrity (RI) on Access Relationships (cc)
https://www.youtube.com/watch?v=_zxxc9jzWEg
Learn Access Playlist on YouTube
http://www.youtube.com/view_play_list?p=1B2705CCB40CA4CA
Warm Regards,
Crystal
~ have an awesome day ~
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: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar