Hi
I am a learner to databases but, an enthusiastc learner.
I have a 'little' problem.g the following I am trying todevelop my own home budget system. I have, among other things a seperate sheet for each month which shows expenditures and income. I am trying to reflect each month ot a seperate 'Summary sheet' and by using the following code for each month am able to transfer the results from each month to this summary: for example Jauary-
DoCmd.OpenForm "frm01januar", acNormal
'
[Forms]![frm2009]![Jan] = [Forms]![frm01januar]![Text16] (Expenses)
[Forms]![frm2009]![janI] = [Forms]![frm01januar]![Text14] (Income)
'
[Forms]![frm01januar].Visible = False
------------------------------
a similar code is used for each month. This is okay until I reach a month which we have not yet reached i.e. June 2009 (does that sound Irish?). The income and expenditure for that and all future months are empty. This presents a problem as I cannot add the columns up as after May they just show blank. I have tried using '0' as a standard value but this doesnt seem to help either.
Can anyone xplain what I am doing wrong and how the correct code should read?
Regards
Tony (Denmark)
[IMG]file:///C:/Users/Tony/AppData/Local/Temp/moz-screenshot.jpg[/IMG]