After many hours of frustration & trying to copy examples from web searching, I'm breaking down & asking for help. :banghead:
I am new to Access & have 2 weeks to recreate an application currently in an online internet app called Trackvia. Anyway, I know this is probably very simple.
I have a text field named Collector in a table (DebtorsT). I want to use it's value to look up a number in another table. If in the Control Source, I hard code the value of Collector it works. If I want to reference the Collector field it doesn't. My hard code that is working piece is:
=DLookUp("[Commission]","[ContractorsT]","FirstName = 'Roger'")
I am new to Access & have 2 weeks to recreate an application currently in an online internet app called Trackvia. Anyway, I know this is probably very simple.
I have a text field named Collector in a table (DebtorsT). I want to use it's value to look up a number in another table. If in the Control Source, I hard code the value of Collector it works. If I want to reference the Collector field it doesn't. My hard code that is working piece is:
=DLookUp("[Commission]","[ContractorsT]","FirstName = 'Roger'")