Changing a subforms record source

[caffeine_demon]

Hi,

I have a form "Parks1" with a subform "childform", and I'd like to change the table that uses based on a set of option buttons. - so I've set macros to run on "gotfocus" for the option button.

Everything I saw suggested that:

Forms!parks1!childform.Form.RecordSource = "table1"
Forms!parks1!childform.Form.Requery

would do the trick - but it doesn't seem to make any difference - whatever I change the recordsource to, it has no effect on the subform, even if I set it to something nonsensical.

Any ideas what's going wrong?

Thanks!

 

[Kreszch68]

Are you sure the event is triggered correctly? Normally you place option buttons within a frame, and use the after update event of the frame to do something with the choosen option value.
Try to place a msgbox line in the code, something like msgbox "Hello", to see if the event is triggered at all.
Further, if the option button is on the form 'parks1', you refer to the subform as: Me.NameOfTheSubform.Form.RecordSource = .

 

[caffeine_demon]

yep - it's definitely triggering, as proved by an msgbox and stepping through,

even if I set it to recordsource="hairyballs" it doesn't even give an error!

 

[caffeine_demon]

interesting, if I put MsgBox (childform.Form.RecordSource) before and after changing the recordsource, the value does change, but it doesn't reflect in the subform....