Hi Everyone,
I am trying to copy a record on the same table using the following code in VB:
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.GoToRecord , , acNew
DoCmd.RunCommand acCmdPaste
DoCmd.RunCommand acCmdPaste
But when I am trying to execute the following code, it copies everything except the order id (which is the primary key in my table) and gives me the following error:
ERROR #: 94
INVALID USE OF NULL
Can anyone help me in solving this error?
Thanks
r143r
I am trying to copy a record on the same table using the following code in VB:
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.GoToRecord , , acNew
DoCmd.RunCommand acCmdPaste
DoCmd.RunCommand acCmdPaste
But when I am trying to execute the following code, it copies everything except the order id (which is the primary key in my table) and gives me the following error:
ERROR #: 94
INVALID USE OF NULL
Can anyone help me in solving this error?
Thanks
r143r