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

 

[TheAceMan1]

How are ya jake7363 . . .

No reason why that shouldn't work. Try:

[blue]   Me.RecordSource = "tblFeb"[/blue]

If that doesn't work instantiate a new blank form (don't add any objects). Set the RowSource to [blue]tblJan[/blue]. Instantiate the button and see if you get the same results . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[jake7363]

I don't know why this works and the other way doesn't, but THANKS!