record source - which event

[Gavx]

I am trying to develop some skills regarding unbound forms.

I have a subform whose record source is bound however I would like to change it to unbound.

Where should I put the record source code? Should it be in an event or just something like Sub FormRecord()?

thanks

 

[JHB]

If you want the data in when the form is open, then in the form's Open/Load event. If you want it when you click a button then in the button's Click event.