A
Allan Koodray
I have two tables with the following parameters:
Table 1
Acct
Jan
Feb
Mar (etc)
Table 2
Acct
Acct Type
The two tables are linked based on "Acct".
I would like to create a data input form that filters
based on "Acct Type" whereby I can have a master form that
has tabs for "Assets", Expenses, Revenues, Taxes... Each
tab would list all accounts of the prescribed "Acct Type".
I am having a tough time tieing the two tables together
ina workable input form. I tried using the filter method
but was unable to get the correct context of the
statement. I also tried creating a subform driven by a
query, however this allowed only a single record, rather
than a list, to be viewed.
Allan
Table 1
Acct
Jan
Feb
Mar (etc)
Table 2
Acct
Acct Type
The two tables are linked based on "Acct".
I would like to create a data input form that filters
based on "Acct Type" whereby I can have a master form that
has tabs for "Assets", Expenses, Revenues, Taxes... Each
tab would list all accounts of the prescribed "Acct Type".
I am having a tough time tieing the two tables together
ina workable input form. I tried using the filter method
but was unable to get the correct context of the
statement. I also tried creating a subform driven by a
query, however this allowed only a single record, rather
than a list, to be viewed.
Allan