Any way to pass a form as an argument to a function??

Hi all,

Is there any way to pass a form as an argument to a function call??

Pls help. Thanks.

Regards,
Tracy

Why?

S-

This is done with regards to the prev prob that i posted here abt having records overwritten in a table and yet is correct in another table.

I intend to clear all the fields on the form "Form1 sub1" except the fields - "PacRef", "ItemNo", "PartNo" on the 2nd attempt to open this form to enter in the 2nd item. The remaining fields will be entered by the user on the details of the 2nd item.

A form has to be passed to the function as an argument because what i'm thinking is to compare the entries in this form and the entry that was previously updated of the 1st item (if any) in the table "bad_parts_return".

If this particular Ref no has no item assigned to it yet, then the form "Form1 sub1" will be opened as usual with the "PacRef", "ItemNo" and "PartNo" passed from the mainform and the subform. If there is at least 1 part being assigned previously, then upon the 2nd attempt to open the form "Form1 sub1", the values of the 3 fields are still passed from the 2 forms but the remaining fields in "Form1 sub1" should be blank for the user to enter data instead of having the previous details of the 1st item.

I'm not sure if i'm making sense here...but that's the only way i can think of topossibly solve the problem of overwritten of data in 1 table.

Another solution that i'm thinking of initially is the way i set he criteria to open the form "Form1 sub1". Wat I had planned to do, was to open the form only when the "PacRef" and "PartNo" of the mainform and subform matched. But I couldn't find a way to multiple criteria for OpenForm.

Any idea what i'm talking abt here?? Probably it'll make more sense when u look at my DB.

Thanks for ur time.

Rgds,
Tracy