Switch in main form to control equation applied in subform?

[alxj]

Hello again my friends more problems i am afraid.

Is it possible to have a yes/no type switch in my main order form which when changed will alter the type of equation used in the subform datasheet. If this is possible how do i go about doing it?.

Thanks for all your help

Alex

 

[simongallop]

Without going into too much detail, you should be able to use the OnChange function of the Yes/No control which has an if statement saying if Yes then formula else other formula