S
sara
I have a simple form whose purpose is to allow the dept manager to change an
employee number on a set of related records. Our employees often use the
wrong number and, when the auditors find it, they want to change it. The
records all have the same EENum, Date and Transaction Number.
I have one combo box at the top of the form and a subform below where I want
to show one set of records (for a EE/Date/Txn) at a time in reverse date
order, using Employee Number (EENum) as the link field.
There are so many employees that show in the drop down list, so I want the
form to have record selectors at the bottom to scroll through that EENUM only
(recordset?) and the subform to scroll through one transaction set at a time.
I can get the Subform to show only one Transaction set (EEnum, SaleDate,
TxnNum - from 2-7 records), but I don't know how to get the record selectors
at the bottom to only go to the next EENum.
Maybe my design is all wrong; I'm new at this and just not sure. I'm happy
to read about how to do this design, too, if anyone can suggest any websites
or something.
I don't know what code to show, so I didn't attach any, but I can.
A great thank you in advance.
Sara
employee number on a set of related records. Our employees often use the
wrong number and, when the auditors find it, they want to change it. The
records all have the same EENum, Date and Transaction Number.
I have one combo box at the top of the form and a subform below where I want
to show one set of records (for a EE/Date/Txn) at a time in reverse date
order, using Employee Number (EENum) as the link field.
There are so many employees that show in the drop down list, so I want the
form to have record selectors at the bottom to scroll through that EENUM only
(recordset?) and the subform to scroll through one transaction set at a time.
I can get the Subform to show only one Transaction set (EEnum, SaleDate,
TxnNum - from 2-7 records), but I don't know how to get the record selectors
at the bottom to only go to the next EENum.
Maybe my design is all wrong; I'm new at this and just not sure. I'm happy
to read about how to do this design, too, if anyone can suggest any websites
or something.
I don't know what code to show, so I didn't attach any, but I can.
A great thank you in advance.
Sara