Thanks John. I didn't know that modal forms inherits the DS of the calling form. This now makes more sense though since I was "reopening" some of the tables (eg. contract table) again in the modal form's DE before running the SQL-SELECT
>Change the DataSession to Public in the modal subform.
You mean Default right?
Anyway, I think I can take over from here. Mighty thanks for your help!
John.
>John,
>
>A modal form run from a form with a DataSession set to Private "inherits" the calling forms data session. Therefore, the tactic to use is:
It's "my" world. You're just living in it.