Feeding a 'live' query...

[Isskint]

No this is not something i have come across. I wonder if you have to treat it like a subform. EG Forms!NavigationForm!MainForm!Subform.Form!ControlName ?

Edit:

Just done some searching and that is essentially correct. The 'Problem' may be the name of the container that holds your form on the navigation form. Apparently the Navigation form wizard changes the name or uses a default name. Check what the container is called.

 

[stevenb82]

I got it to work!! Whohoo.. lol

Your information on how to print the report from the form was excellent, thanks a lot! You have saved me a lot of hassle, still think I'll learn VB though..

I'll write up a complete post on exactly how I got it to work in case its of any use to any other members..

 

[boblarson]

The syntax for the navigation form is special:

Forms!Navigation Form!NavigationSubform.Form!ControlNameHere

You ONLY change the parts in bold red. The rest stays EXACTLY as is.