changing the record source of a closed form

[mchd]

Hi,

Is it possible to change the source of a closed formula. If so how to do it
?

Thanks for any help

 

[Pavel Romashkin]

Could you tell us why you want this?
I suspect you want the form to have a different record source as it
opens up? If so, you can define the record source at launch in Load
event, or in code opening the form. The updated recordset will be there
when it shows up on the screen.

Pavel