I have a data entry form where the user enters an AdHocID in a textbox and selects a location from a listbox. This listbox contains an associated TreatmentTypeID. I'd like to have another text box that shows a calculated SampleID = AdHocID + (100000)*(TreatmentTypeID) and then stores that calculated value in the SampleID field of the form's RecordSource. I don't understand how to specify the calculated value to be stored in the SampleID field of the recordsource. Am I missing something? Is this even possible?
Here's the expression I'm using in the form:
=[AHID]+(100000*(Forms![Ad Hoc Entry Sheet]![Location and TreatmentType IDs].Column(4))
Unfortunately this isn't even showing up correctly in the form and just returns #NAME?. HELP!?!