>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.
You need to declare it so that it's in scope at any time that you update it by issuing a USE or REQUERY; I normally declare a local of the appropriate name immediately before requerying the view in question in code, and populate the variable from a form property.