Refresh Report within Form

Question

I have a form with a few data entry fields, with a report below. The idea is that as the user enters data, the report gets updated with the new records. I am having difficulty getting the report to "refresh" after the user selects a "Save Record" button.

So far I have tried the following:

1) Using the action builder from the On Click ellipsis, I added the action "Refresh". This results in an error message "No Current Record"

2) Using VBA, I tried the following

Function refreshBCP()
Forms![enter_BCP].[bcp_list].Requery
End Function

This does not result in the report showing any updates

3) Manually refreshing with F5 works as long as the cursor is not within any of the data entry text boxes. However, this is far from an optimal solution.

I've also gone down the Google rabbit hole, but so far have been unable to find a method that solves my problem

Any help is appreciated

Answer 1

well first - Microsoft Access offers a standard split form with the exact same look as what you've created. Look at the Create - Form Wizard for it. It has the Single Form at top and the Continuous Form on the bottom.

you are using a sub report on the bottom but it is essentially the same thing....only a sub form.

in your case there are 2 events which are not clear:
a. is the data written to the table. although it displays on screen it may not be - it probably is assuming it is a bound form...when you tab let's say to the sub report control...look at the table and see that the data is there...

b. then in the appropriate text box's After Update event use:
me.SubReportName.requery

that subReportName should auto complete via intellisense... if it does not you don't have the correct control name (which can differ from the report object name)...look at its sub report property pane.