Changing RecordSource of subform

[Help.Chris]

Hi everyone,

Thanks for any help in advance.

I am trying to change the recordsource of a subform at runtime, i know this can be done but cannot get my syntax correct in my vba.

The line needs to be in the main form, as a search utility is held there.

The main form is called [Campaign Search Form]

The subform is called [Campaign Discounts Form]

I have then got two queries ready called "Temp1" and "Temp2".

I want to be able to switch between these.

Could some please help, and provide me the correct syntax for these form names.

Thanks

Chris