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
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