Column Headings

[learning_codes]

Hi,

I'm wondering if it will work or not. Your feedback would be much
appreciated and give some example if possible.

In a query, it has Column Headings and every year, I have to go and
change from "1999","2000" and then change to "2002","2003" and remove
"1999".

Is there a form that has two text box where I can put 2002 and 2003 to
replace 1999 and 2000. and put it in a view before generating the
query?

Again, your help would be much appreciated.

Thanks

 

[Klatuu]

If you are using a form in datasheet view with the query as the form's record
source, you can change the labels' captions for the controls the fields are
bound to in the Load event of the form. You can do it programmatically:

With Me
.lblThisYear = Year(Date)
.lblLastYear = Year(Date) - 1
End With