Trying to change recordsource

[jake7363]

Hi,
I have two tables: tblJan, tblFeb

I have 1 form: frmMonth.

I am trying to use a command button to change the recordsource to view another month. Here is what I have:

Sub cmdFeb_Click()
Forms!frmMonth.RecordSource = "tblFeb"
End Sub

An error message appears as follows:

"Run-time error '3251':
Operation is not supported for this type of object"


If this doesn't work, how can I get the recordsource to change to Feb?

Thanks in advance,
Jake

 

[rainman89]

Normalize your data!!!!!!!!! Search on normalizing.
you need one table tblmonth!!

 

[jake7363]

Perhaps my thinking is skewed or I just plain don't understand, but the reasoning for the tables by the individual months (12 in all). is that it seemed simpler to change the recordsource by the month rather than making filters to sort by the months, which are entered in "short date" format. As well, it makes it easier for the individuals doing the data entry to keep track of the month by month stats, since they are not all that skilled in computers.

I'm not quite sure why the stress of "normalization", because there are not that many fields and the tables are simple (8 fields) , plus they are layed out exactly the same.

That being said, is there a way to accomplish what I am seeking?

Thanks again.

Jake