Problem with next/lastrecord

[Sport]

I have put code in place to check and see if you have reached the last
record; by comparing the recordcount to the current recorded. If they are
at the last record they get a message box telling them so. The problem is
that now when the DB is opened on multiple PC's the record is not
incremented; if PC A enters a new record, PC B can not move forword to it as
it thinks that it is at the last record already. Is there a way to refresh
the recordcount?

Thanks.