Programmatically changing the Record Source

[Nelmo]

How do I change the Record Source of a Form from a Command Button on the same Form?

i.e. Form = frmA
Record Source = qryA

Click a button to change the Record Source, to:

Form = frmA
Record Source = qryB

Thanks in advance

NEL

 

[Mile-O]

amazingly

Me.RecordSource = "MyQuery"

 

[Nelmo]

Thanks Mile-O-Phile


So easy when you know how!!!!


NEL

 

[nescartel]

Thanks Mile-O-Phile!!! i have been finding this answer for like 2 days now!!! THANX A MILLION!!!

 

[nescartel]

one more thing, is there any way i can set the record source from a combo box? i would like to have a combo box that contains a list of selection, and when the user updates the combo box, i want the subform to have a new record source as selected. can anybody help me out? thanx in advance...