Invalid bracketing error (1 Viewer)

sm1810

New member
Local time
Today, 07:31
Joined
Apr 12, 2018
Messages
8
Hi looking for some help with this bracketing error!
Thanks
Main form - navigation form
Subform - Follow up day 01
field - hospitalno

query works perfectly if I use the criteria [Forms]![Follow up day 01]![hospitalno] from the form follow up dau 01 directly ...but not if trying to use it form the navigation form

Thank for your help
 

Attachments

  • bracket error.jpg
    bracket error.jpg
    69.3 KB · Views: 95

Ranman256

Well-known member
Local time
Today, 02:31
Joined
Apr 9, 2015
Messages
4,337
you missed a bracket
![follow up day1]![form]!

If you use BUILDER , it never gets it wrong.
 

sm1810

New member
Local time
Today, 07:31
Joined
Apr 12, 2018
Messages
8
you missed a bracket
![follow up day1]![form]!

If you use BUILDER , it never gets it wrong.


Thank you, thank you.... worked like a charm..
 

Users who are viewing this thread

Top Bottom