Hello - I have a subform that has a field called FileID. When a certain event is triggered, I want to set a text box on the main form = FileID. I'm using the simple code below. The text box has no events, etc. so I can't imagine there's a recursive thing going on. But I keep getting a "too complicated expression" error. Help please?!? THANKS!
Code:
Forms("usysfrmMain").Controls("zFileID").Value = iFileID
'I've also tried this:
Forms("usysfrmMain").zFileID.Value = iFileID