I have a form A which is a subform of Form B. I am using Form A only to fetch records into form B and hence i dont want a record to be created in Form A table when i create a record in Form B.

Is there a way around it? As i understand a sub-form will create a record in the back-end and we cant change it.

But can we find a way around it so that i can still fetch records from Form A to Form B and not create a record in Form A.

I cant use the normal Fetch records because Form A is fetching data from another Form C.

Suggestions Please???