https://www.webmaster-forums.net/crss/node/1039670 en https://www.webmaster-forums.net/web-database-development/ms-access-applyfilter#comment-1224790 <blockquote class="bb-quote-body"><p><strong>teammatt3 wrote:</strong> I tried running a Macro that OpenForm's</p></blockquote> <p>Hmmm, you were using a Macro or running some VB code on an event. They're two different things: Macros == old skool and bad, VB code == new skool approved by Microsoft goodness.</p> <p>If you were to do this again (sorry I missed your post first time round <img src="https://www.webmaster-forums.net/misc/smileys/eyeroll.png" title="Roll eyes" alt="Roll eyes" class="smiley-content" />), try setting the SQL the subform (is it a subform or a linked form?) is based on in the code of your DoubleClick event. Does that make sense?</p> <p>Glad you got it working though. <img src="https://www.webmaster-forums.net/misc/smileys/smile.png" title="Smiling" alt="Smiling" class="smiley-content" /></p> Mon, 01 Oct 2007 17:39:20 +0000 JeevesBond comment 1224790 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/ms-access-applyfilter#comment-1224759 <p>I guess I can't refer to values in subforms properly. What I ended up doing was making a text field on the main form, which held the value of the field on the subform. Then on my applyfilter, I just referenced the field on the main form, not the subform. Weird.</p> Mon, 01 Oct 2007 03:23:01 +0000 teammatt3 comment 1224759 at https://www.webmaster-forums.net