Reply to thread

Message: [QUOTE="BruceM via AccessMonster.com, post: 1987783"] Me.Controls("ControlName") uses the name of the control only. "Forms! Results1" is extraneous. stPrac = "Mod" & stMod & "Ass" & stAssNo & "Prac" stAcad = "Mod" & stMod & "Ass" & stAssNo & "Acad" The rest of the code looks OK. If you need to see what a string (or any variable) looks like after it is assmbled, add this line of code after you have set the variable (in this case, directly after the stAcad line of code): Debug.Print stPrac Debug.Print stAcac After you run the code, press Ctrl + G to open the immediate code window. The strings will be shown there. It's best to remove or comment out the Debug lines of code after you are done testing (before you start using the database for real). [/QUOTE]