I'll preface this issue that I have little experience with reports in relation to the code builder.
What I am trying to accomplish is filling in several text boxes on my report using combo boxes that a user would select on a previous form.
For example:
Other lines are similar direct transfers and DLookup.controlsource, etc.
The issue is that the report preview does not seem to update these fields. I assume this is because of how the openreport command generates based on initial values of each text box. I tried OpenArgs or opening the report again, but none of these seemed to change anything. Is there a crucial step that I'm missing here or another way around this or is this a hard limitation for Access
What I am trying to accomplish is filling in several text boxes on my report using combo boxes that a user would select on a previous form.
For example:
Code:
DoCmd.OpenReport "Singlesourcedreport", acViewPreview
Reports!Singlesourcedreport.txtcatalog = Me.txtcatalog
Other lines are similar direct transfers and DLookup.controlsource, etc.
The issue is that the report preview does not seem to update these fields. I assume this is because of how the openreport command generates based on initial values of each text box. I tried OpenArgs or opening the report again, but none of these seemed to change anything. Is there a crucial step that I'm missing here or another way around this or is this a hard limitation for Access