Counter wont update?

[NewfieSarah]

Hey all, here is my problem. I have a form with my 5 different counters on there and well they are not updating. I can update them on the main page but not on the other pages. I have a page called PID where there are 4 command buttons and counters. I click on the first command button, and add a record there now I would go back to the main page PID and the counter needs to update. How do I do this?? the code I have for to create the counter on the main page is as follows, However I need to enter the building form, and add or delete a record and have the counter on the main page update once finnished with that form. I hope I explained this good enough for someone to help. Thanks in advance.

'Building recordset
On Error Resume Next
If bdg.EOF And bdg.BOF = True Then
bdgcount = 0
Else

With bdg
.MoveFirst
.MoveLast
bdgcount = .RecordCount
End With

End If

 

[supercharge]

You may have to refresh your main page. I would do a quick refresh by uh...close and open the form back.

 

[Pat Hartman]

You don't need code at all. Add a footer to the form and add a control to the footer. Use the following as the controlSource.

=Count(*)

 

[NewfieSarah]

Thanks for all the help guys and gals!

 

[supercharge]

See attached.

 

[NewfieSarah]

It doesnt not recgonize my form name for my main form. it has been doing this since I starting working with the program. why is this it is spelt right, I dont know...

 

[supercharge]

My sample is a "sample" only, it has none of "your" forms in it. Look for how I've done it and use it for your form.

 

[NewfieSarah]

I know that it is a sample, however I changed the code to suit my program but it is not verifying my main form name, I was thinking maybe you had some ideas where I could check the name or something... thanks again