Tabular Form Record Source

[Russie]

Hi.

I have a tabular sub-form that is requeried when a routine is run.

Is there anyway that I can have a dynamic record source for my sub-form...i.e. if condition = true then strSQL=x and if condition = false Then strSQL = Y.

I'm refreshing the sub form using Me.subform.Requery. Is there any way that I can manipulate its record source from my parent form?

A star for a right answer..or a star for even a steer that helps me to solve the problem.

Thanks very much.

Russie

 

[GoDawgs]

You can set the recordsource for the subform the same way you requery...me.subform.recordsource=... just put it in the if statement like you say. Let me know if anything is confusing...hope that helps.

Kevin

 

[Russie]

Hi godawgs

I tried it and it didn't work..Recordsource isn't an available method of Me.Subform.

Does anyone else know of setting a recordsource on a subform?

Thanks.