P
postman
i have two forms, "Frm_Contracts" & "Frm_Customers", & a sub-form "ds_TAG ID List" which i want to open in datasheet view.
a button on the "Contracts" form opens the "Frm_Customers", then a button on "Frm_Customers" then opens the "ID TAG List" (in datasheet view).
to open the "ID TAG List" form in datasheet view i did as [email protected] suggested & put this line into the on click event procedure of the button on the "frm contracts":
DoCmd.OpenForm "ds_TAG ID List", acFormDS
I deleted the original command button line:
DoCmd.OpenForm stDocName, , , stLinkCriteria
and replaced it with the line above. Should I have done that?
It works nicely but now the button on the "Contracts" form that opens the "Customers" form throws an error when pressed:
Object'aad_tempSmartFormQueryDef_Frm_Customer' already exists. ok.
In fact throws the error when opened manually also.
What am i doing wrong with this button? help please.
Thanks in advance.
a button on the "Contracts" form opens the "Frm_Customers", then a button on "Frm_Customers" then opens the "ID TAG List" (in datasheet view).
to open the "ID TAG List" form in datasheet view i did as [email protected] suggested & put this line into the on click event procedure of the button on the "frm contracts":
DoCmd.OpenForm "ds_TAG ID List", acFormDS
I deleted the original command button line:
DoCmd.OpenForm stDocName, , , stLinkCriteria
and replaced it with the line above. Should I have done that?
It works nicely but now the button on the "Contracts" form that opens the "Customers" form throws an error when pressed:
Object'aad_tempSmartFormQueryDef_Frm_Customer' already exists. ok.
In fact throws the error when opened manually also.
What am i doing wrong with this button? help please.
Thanks in advance.