Is there a specific string format to specify a sub form in the SearchForRecord command?
I first set the focus on the target field in the sub form.
I tried "Forms![MainFormName]![SubFormName].form" but VBA cannot find the form and error is shown.
Is there a specific string format to specify a sub form in the SearchForRecord command?
I first set the focus on the target field in the sub form.
I tried "Forms![MainFormName]![SubFormName].form" but VBA cannot find the form and error is shown.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba