I have a separate front and back end for my database. I`m trying to merge them into one application, for easier distribution to users, but I`ve found that things that worked previously now produce errors, even though all I`ve done is import the tables as opposed to linking to them.
For example, the line:
Forms!Referrals!Paycode = str_Paycode
works perfectly if using linked tables, but if the links are all removed and the exact same tables are imported, I get the message 'Object invalid or no longer set'.
Is there some difference between linked and 'in-built' tables that I'm missing? I'm largely self taught and have tended to learn things as I needed them, so I may have missed something important.
Any suggestions gratefully received.
For example, the line:
Forms!Referrals!Paycode = str_Paycode
works perfectly if using linked tables, but if the links are all removed and the exact same tables are imported, I get the message 'Object invalid or no longer set'.
Is there some difference between linked and 'in-built' tables that I'm missing? I'm largely self taught and have tended to learn things as I needed them, so I may have missed something important.
Any suggestions gratefully received.