Please find attached my sample database that demonstrates the problem I am having.
I am trying to display values in a subform using the link master and child fields.
Only the subform does not seem to recognise the main form values that have been passed to the form as global variables or as openarg
To show the problem do these steps:
1. Open the form frmMain
2. Type number 198 into the text box and click OK.
A pop up form opens and displays the main form values passed in as globals/openarg but does not display the parameters in the subform.
Now when you comment out the main form values passed in as globals etc and uncomment the same values that are hardcoded, the parameters in the subform are displayed.
Note - To comment/uncomment open frmAddNewScheduledReportInstance in design view and go to Visual Basic.
I would appreciate if someone could explain what is the issue here and suggest a fix.
Many thanks in anticipation.