Hi all,
I'm new here so I hope I don't do this wrong. I am self taught with Access and VBA and have been learning through trial and error and Google. I have created a database for work. It is split and there are 4 different front ends, each used by different people depending on their job. Some are data entry, some are quality control, some are research, etc. and have different needs.
I have a form with a subreport and a subform.
Form = frmMain
Subform=frmSQJunction
Subreport=rptSQJunction
The form displays the account info. The subreport displays the errors previously selected on the account from a junction table. The subform allows them to add additional errors via a multiselect listbox that saves to the junction table. I would like to click an "Add" button and have the subreport update to show the newly added errors as well. They appear there if I leave the record and go back, but I cannot figure out the proper syntax to requery the subreport from within the subform in the on click event. I hope I have explained it clearly. Any help is greatly appreciated. Thank you!
I'm new here so I hope I don't do this wrong. I am self taught with Access and VBA and have been learning through trial and error and Google. I have created a database for work. It is split and there are 4 different front ends, each used by different people depending on their job. Some are data entry, some are quality control, some are research, etc. and have different needs.
I have a form with a subreport and a subform.
Form = frmMain
Subform=frmSQJunction
Subreport=rptSQJunction
The form displays the account info. The subreport displays the errors previously selected on the account from a junction table. The subform allows them to add additional errors via a multiselect listbox that saves to the junction table. I would like to click an "Add" button and have the subreport update to show the newly added errors as well. They appear there if I leave the record and go back, but I cannot figure out the proper syntax to requery the subreport from within the subform in the on click event. I hope I have explained it clearly. Any help is greatly appreciated. Thank you!