>I would like to include a paramaterised view within the forms DE and would like to know what the recommended way of doing this is. I can obviously declare a public variable in the DE in the before load tables method but this seems a bit clumsy. Is there a better alternative? I have looked in the FAQs and the MS support area but have had no joy.

Mike,

In the DE make the view's NODATAONLOAD property .T.. Then in the form's Init you can set the parameter and Requery("TheView") to get the data.