How to make a cross-tab query on a form interactive.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I've created an cross-tab query for visualisation my monthly expences, like
this:

Feb 2006 Jan 2006 Dec 2005 ...
Clothing 45,00 60,00
Food 99,00 75,00 97,00
....

The query itself works fine, even if i limited the months (with the between
function).

So, to change these 'between' two months i wish to type them in a textbox
before i refresh the subform.
However, as soon if i make a subform based on the crosstab-query the values
and number of the labels for the months become permanent on the form and
don't change if i choose other months.

How can i make these query properly working on a form. I use Access 2000.
 
Try set the SourceObject of your subform using code like:

Me.fsubOne.SourceObject = "Query.qxtbMyCrosstab"
 
Duane, thank for your reply but it won't work. I still need to put fields
on the form.

However, this morning i thought on something about using a listbox linked
to a SQL-string.

And it's working but with two minor problems:
1) Sometimes i need to scroll the list to see other months, in that case the
first column disappears from the screen. How can i freeze it??

2) The alignment of the values are leftsided. Is there a possibility to
changed it??

In the cross-tab query i can't refer to a field on a form for criteria so i
make the sql-string with visual basic and put it programmaticly into the
rowsource.
 
Search google groups on this string to see if the solution works for you.
fsubone query "fsubone" group:*access* author:hookom
 
Back
Top