H
hkgary33 via AccessMonster.com
Dear all,
In my database, I’ve built a main form called frmVIEW which is linked with a
sub form called sfrmDUP. In the frmVIEW, it shows one record in tbl_FileInfo
in a time (a singular form), and two important fields are included to be
shown:
1) File_No: It is the unique key that identifies each record
2) District: It shows the district taken place of each file
Since we’re particularly interest in duplicated districts, what I would like
to do is once the frmVIEW is shown, it will seek the district of current
record, and then search in the tbl_FileInfo to see whether there are other
files with same districts as the current record, and the result will be shown
in the sub form sfrmDUP simultaneously. And even I navigate to other records,
the records in sfrmDUP will be updated accordingly.
Can anyone kindly solve the above problem?
Thanks a lot!!!!
Gary
In my database, I’ve built a main form called frmVIEW which is linked with a
sub form called sfrmDUP. In the frmVIEW, it shows one record in tbl_FileInfo
in a time (a singular form), and two important fields are included to be
shown:
1) File_No: It is the unique key that identifies each record
2) District: It shows the district taken place of each file
Since we’re particularly interest in duplicated districts, what I would like
to do is once the frmVIEW is shown, it will seek the district of current
record, and then search in the tbl_FileInfo to see whether there are other
files with same districts as the current record, and the result will be shown
in the sub form sfrmDUP simultaneously. And even I navigate to other records,
the records in sfrmDUP will be updated accordingly.
Can anyone kindly solve the above problem?
Thanks a lot!!!!
Gary