Recordsource of a Datasheet Subform

[bulent]

My problem is about a form that's using a datasheet subform. I create an SQL with the fields on the main form then I try to set the Recordsource of the datasheet. But the result is negative. (I can set the recodsource of the continuous subform with the same method.)

Do you know a way to set the RecordSource of a datasheet subform ?

 

[bulent]

I found the answer in the same day! I'm giving the answer of my question below.

The wrong line is:
me.form.mysubform.recordsource = sourcesql

The correct one:
me.mysubform.form.recordsource = sourcesql

Now I can sort my data.

 

[BobBoudreau]

I want to add Calendar Control 10 to an Access Data Page and have the user activate the control from a command button. I set the Calendar Control property to "Hidden" and tried to have the control made visible through the command button; but, I do not seem to be able to achieve this. Can someone advise me of a VBScript syntax that will do this ?