C
CB
I'm having issues with one of my forms and sub-form now
that I've been upgraded to Access 2002. I had no issues
whatsoever using Access 2000. There has been no change to
the data access project so I have no idea what the issue
is. I didn't build the database but I am responsible for
administering it (Front end built using Access 2000 and
back end is SQL Server).
On the first form, the tech selects a product from a combo-
box (record source is a SELECT statement querying the
products table) then enters a serial number in a text
box. When the tech selects the 'GO' button one of two
things is supposed to happen (in a nutshell):
i) if there is an existing record based on the product and
serial number but the record is incomplete, the record
should open (in a form with a sub form) allowing the tech
to finish entering test results
ii) if there is no record based on product and serial
number or if the previous test record indicates a pass, a
new record should open (in a form with a sub form)
allowing the tech to enter new test results.
FrmCoCMain is a form containing a sub form. The sub form
changes depending on the product selected. The chosen
product is passed to frmCoCMain whereas the serial number
is passed to the sub form. Both pieces of information are
saved in the same underlying table along with data entered
in the sub-form.
My issue is that now (in Access 2002) when I select 'GO' I
get the error "-2147352567: You can't assign a value to
this object." Using some debugging, I've narrowed the
offending line of code to the following:
frmCoCSub.SerialNum = Me.txtSerial
But I don't get why thing no longer works! ARGGGGHH!
Please let me know if you need to see more code to see the
context in how the above was used.
Thanks for any and all help!
that I've been upgraded to Access 2002. I had no issues
whatsoever using Access 2000. There has been no change to
the data access project so I have no idea what the issue
is. I didn't build the database but I am responsible for
administering it (Front end built using Access 2000 and
back end is SQL Server).
On the first form, the tech selects a product from a combo-
box (record source is a SELECT statement querying the
products table) then enters a serial number in a text
box. When the tech selects the 'GO' button one of two
things is supposed to happen (in a nutshell):
i) if there is an existing record based on the product and
serial number but the record is incomplete, the record
should open (in a form with a sub form) allowing the tech
to finish entering test results
ii) if there is no record based on product and serial
number or if the previous test record indicates a pass, a
new record should open (in a form with a sub form)
allowing the tech to enter new test results.
FrmCoCMain is a form containing a sub form. The sub form
changes depending on the product selected. The chosen
product is passed to frmCoCMain whereas the serial number
is passed to the sub form. Both pieces of information are
saved in the same underlying table along with data entered
in the sub-form.
My issue is that now (in Access 2002) when I select 'GO' I
get the error "-2147352567: You can't assign a value to
this object." Using some debugging, I've narrowed the
offending line of code to the following:
frmCoCSub.SerialNum = Me.txtSerial
But I don't get why thing no longer works! ARGGGGHH!
Please let me know if you need to see more code to see the
context in how the above was used.
Thanks for any and all help!