I've noticed a couple of things with your code.
First of all, Date_Closed.Visible = Now() doesn't seem like an appropriate line. Try using True instead.
Secondly, Tab Controls do not have an AfterUpdate event.
In your Form_Current() method try something like this
Private Sub...
You should be able to use the RecordSource property to get the data source for the report. You can open a new Recordset based on the report source, then use the method that you used on the form. I've written the example below using an ADO Recordset, but you should get the idea.
Dim rst...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.