ConfusedChap
Programmer
Hi all,
i usually use this forum to look up some solutions to problems but this time i can't find anything useful.
Its regarding the runtime error 2448 'you can't assign a value to this object'. I've seen that quite a few people have had this problem but mine is weird compared.
I recently created a database for donors and i have a finance table and a donor table that are linked by a finkey. I have a main form which has subforms for the donors, finance and other relevant forms that the user enters data onto. I had a little VBA code that populated the FINkey in the donor table based on the finkey in the finance table. All worked perfectly.
I then went ahead and copied the same database without making any changes except to populate all the tables with different data for a different set of donors. However, this time i get the above error message when it tries to populate the finkey! Please help if you can as I am completely stumped as to why this has happened??
Here is the code I am having the issue with (the **** line is the one it has having the issue with -
Private Sub Amount_LostFocus()
Me!Batch_Number = Forms!frmMain.txtBatchNo
Me!PayMethod = Forms!frmMain.txtPayMethod
Me!Date = Forms!frmMain.txtDate
Me!Campaign = [Forms]![frmMain]![Source_f].[Form]![Campaign]
**Me!FinKey = [Forms]![frmMain].[FinKey]**
Any help is much appreciated, cheers.
i usually use this forum to look up some solutions to problems but this time i can't find anything useful.
Its regarding the runtime error 2448 'you can't assign a value to this object'. I've seen that quite a few people have had this problem but mine is weird compared.
I recently created a database for donors and i have a finance table and a donor table that are linked by a finkey. I have a main form which has subforms for the donors, finance and other relevant forms that the user enters data onto. I had a little VBA code that populated the FINkey in the donor table based on the finkey in the finance table. All worked perfectly.
I then went ahead and copied the same database without making any changes except to populate all the tables with different data for a different set of donors. However, this time i get the above error message when it tries to populate the finkey! Please help if you can as I am completely stumped as to why this has happened??
Here is the code I am having the issue with (the **** line is the one it has having the issue with -
Private Sub Amount_LostFocus()
Me!Batch_Number = Forms!frmMain.txtBatchNo
Me!PayMethod = Forms!frmMain.txtPayMethod
Me!Date = Forms!frmMain.txtDate
Me!Campaign = [Forms]![frmMain]![Source_f].[Form]![Campaign]
**Me!FinKey = [Forms]![frmMain].[FinKey]**
Any help is much appreciated, cheers.