N
Nelly
Dear all
I'm no about 2 days trying to find a solution to the following
problem:
I have a form with different subforms and a mainform.
In 1 of the subforms I can enter the following data (continous form):
- Year (2003 or 2004....) - Combobox
- Type (costs or savings) - Amount
- Amount (for every month of the year (textbox)
There are additional fields like Cost Center and Account.
In a 2nd subform I would like to get an overview about the entries as
follows (the years are in this form are dynamic):
2003 2004 2005 2006 2007
Costs x y z ... ...
Savings a b c ... ...
Total (not part of the problem)
I now tried to put a listbox for each x, y, z, a, b, c a.s.o containing
a query under RowSource that shows the following
with the conditions for x: Year = 2003 AND Costs = 1 (1 = Costs):
Aggregated Amount No Datarecord(of Mainform)
100'000 1
150'000 2
When I now check the value on the subform in the listbox I find
the correct amounts by datarecord.
Problems: - When the 1st Record has a value and the following not
the value is still visible and therefore gives a wrong
view.
- The listbox (and combobox) looks a bit silly, since it
shows the arrows that are not really necessary in this
case.
Did one of you guys did have already such a problem?
Please, please help me!!!
Thanks and regards,
Nelly
I'm no about 2 days trying to find a solution to the following
problem:
I have a form with different subforms and a mainform.
In 1 of the subforms I can enter the following data (continous form):
- Year (2003 or 2004....) - Combobox
- Type (costs or savings) - Amount
- Amount (for every month of the year (textbox)
There are additional fields like Cost Center and Account.
In a 2nd subform I would like to get an overview about the entries as
follows (the years are in this form are dynamic):
2003 2004 2005 2006 2007
Costs x y z ... ...
Savings a b c ... ...
Total (not part of the problem)
I now tried to put a listbox for each x, y, z, a, b, c a.s.o containing
a query under RowSource that shows the following
with the conditions for x: Year = 2003 AND Costs = 1 (1 = Costs):
Aggregated Amount No Datarecord(of Mainform)
100'000 1
150'000 2
When I now check the value on the subform in the listbox I find
the correct amounts by datarecord.
Problems: - When the 1st Record has a value and the following not
the value is still visible and therefore gives a wrong
view.
- The listbox (and combobox) looks a bit silly, since it
shows the arrows that are not really necessary in this
case.
Did one of you guys did have already such a problem?
Please, please help me!!!
Thanks and regards,
Nelly