Trying to get Search Bar Function to Filter Subform Query

[Bkper087]

I have learned through trial and error that using the method I have learned to search and filter forms does not work within Navigation Forms. I have previously used a formula similar to the one below under the "On Click" command for a button that filtered a split form. The bottom half of the form would sort. In a Navigation Form it appears that the records do not show up in the bottom half of the split form. Is there an easy way to fix this or is there another way to accomplish the same task?



[BusinessName] Like "*" & [Forms]![sublktBuisnessF]![SearchBar] & "*"

[Micron]

Never done what you're up to, but I'll say your reference is probably not right.
Try this syntax

Forms!MainFormName.SubformControlName.Form.ControlOnForm

Note - SubformControlName is the name of the subform control, not the sub form. I'm guessing that SearchBar is a control. Sorry if I'm way off base.