J
jmd
I have (1) master table to store transactions for a student merit-based
"payroll" system.
Main Form:
Student Info
Subform:
I have a tabbed control with (3) separate data-entry subforms feeding the
master table, each form is built to suit the transaction with a "CATEGORY"
field (Income, Behaviors, Savings) to dilineate between the forms, and a
"TRANSTYPE" field (Base Income, Bonus Income, Pink Slips, Blue Slips, etc) to
group transaction types. I'm trying to build a "simple" filter to delineate
the transactions between each form.
I've tried the following:
1. Form/Filter property I use - (((tblTransactions.Category)="Income")) -
works sporadically - the data gets unsynched
2. VBA tied to subform/OnEnter event property:
dim strIncFilter as String
strIncFilter = "(((tblTransactions.Category)='Income'))"
DoCmd.ApplyFilter strIncFilter
as well as
DoCmd.ApplyFilter ""(((tblTransactions.Category)='Income'))"
The filter doesn't kickI then get a prompt to provide a parameter value for
tblTransactions.Category, I click OK and the filter works
I'm sure it's something stupid, it always is, I've researched a variety of
ways to make these filters work and I've tried far more than the 2 things
I've listed. Any help would be greatly appreciated.
"payroll" system.
Main Form:
Student Info
Subform:
I have a tabbed control with (3) separate data-entry subforms feeding the
master table, each form is built to suit the transaction with a "CATEGORY"
field (Income, Behaviors, Savings) to dilineate between the forms, and a
"TRANSTYPE" field (Base Income, Bonus Income, Pink Slips, Blue Slips, etc) to
group transaction types. I'm trying to build a "simple" filter to delineate
the transactions between each form.
I've tried the following:
1. Form/Filter property I use - (((tblTransactions.Category)="Income")) -
works sporadically - the data gets unsynched
2. VBA tied to subform/OnEnter event property:
dim strIncFilter as String
strIncFilter = "(((tblTransactions.Category)='Income'))"
DoCmd.ApplyFilter strIncFilter
as well as
DoCmd.ApplyFilter ""(((tblTransactions.Category)='Income'))"
The filter doesn't kickI then get a prompt to provide a parameter value for
tblTransactions.Category, I click OK and the filter works
I'm sure it's something stupid, it always is, I've researched a variety of
ways to make these filters work and I've tried far more than the 2 things
I've listed. Any help would be greatly appreciated.