Changing the record source with VB codes

[Kevin]

How do I change the form record source property? I want a
form uses query1 if opened from form1 and uses query2 if
opened from form2.

Is it possible to do it?

Many thanks

 

[Larry]

I did something like this, sometime ago. It'll take me some time to find the
example, but I thought I'd give you something to go on, for now.

I believe what I did, was create a Form object in the form that will do the
opening, then set the control source of that form object and finally did a
form.show to display the form.

Just off the top of my head, I think it was something like that. You may
give that a try and I'll see if I can find the database I did that in (they
all start running together after years of this stuff!).

HTH