Recent content by KimH

JDRAW – I am familiar with the article you quoted, but in my application [screen].[activeForm] is not being used in a macro, so it does not apply in this instance. I use [screen].[activeform] to filter the Row Source query on the Architect combo box which is on the Architect subform. It points...

OK. So it works if I explicitly reference the form, but why isn't working when I use the screen.activeForm rather than the explicit reference to the form? These subforms are being used on two main forms, which is why I went with screen.activeForm. Not a big deal in this instance to create a copy...

I work for a General Contractor and am working on a client database. For each project there may be multiple architect firms assigned to the project and multiple architects within those firms assigned. I went back and forth trying to decide which made the most sense from a design perspective: -...