Changing record source in VBA

[Smee]

Hi Guys

Is it possible to change a forms record source from within an event procedure?

i.e Form Rates record source is currently Table [x] and I need to change it to Query [y].

I will then need to set which field each of the text boxes uses in the new record source.

Basically I need to play with the properties control options with VBA

Any and all help greatly apprieciated.

Thanks

Smee

 

[Mile-O]

For a form's RecordSource:

Me.RecordSource = "MyQuery"


For a control's ControlSource:

Me.ControlSource = "MyField"

 

[Smee]

Thanks mile