title: Access VBA SubForm Not Filtering Other Subform When Embbedded in Navigation Form
body: <p>I have an unbound form with two subforms embedded into a navigation form, like this:</p>
  
  <p><img src="https://i.stack.imgur.com/N3Tds.png" alt="enter image description here"></p>
  
  <p>On the subform on the left side, I have the following code related to the OnFocus Event of the CustomerName field, which filters the subform on the right to show the customer detail that is selected from the right:</p>
  
  <pre><code>Private Sub CustomerName_GotFocus()
  
  Forms!frmCustomers_sjh![Customer Address Form].Form.Filter = "CustomerName = '" &amp; Me.CustomerName &amp; "'"
  Forms!frmCustomers_sjh![Customer Address Form].Form.FilterOn = True
  
  End Sub
  </code></pre>
  
  <p>This works great when I have the frmCustomers_sjh open by itself, but it craps out when I run it from the Navigation form. I get Run-Time Error '2450' that Access can't find the referenced form 'frmCustomers_sjh`.</p>
  
  <p>I've done enough research to know that running the code within the navigation form is different and a bit trickier to play with, but I haven't been able to solve the issue here. </p>
  
  <p>Things to note:</p>
  
  <ol>
  <li>Not using the Navigation Form is not an option (client requirements)</li>
  <li>Splits Form are not an option either, as I need a search directory on only customer name on the right, with a detail form on left.</li>
  <li>I am open to any other design solutions, as my understanding of Navigation Forms is low since I just started playing with it.</li>
  </ol>