Are you discussing the Frm_Members in some template or sample database? If
so, it would be a really good idea to tell us instead of assuming that we
would make the connection. I can reliably predict that few, if any, will go
out and search to see if they can find something that has a Frm_Members with
a "Books_out" field, just to be able to respond to a newsgroup question.
Do you mean you are using the Nav Bar on Frm_Members to go to a new record?
The Nav Bar itself neither adds nor edits records -- it is for "navigation",
moving within the RecordSource.
Unless there is compelling reason to use code, "Books_Out" will be
recalculated whenever a different record is displayed, if you will use a
=DCount (...) statement as its Control Source, without any other action
necessary on your part.
Larry Linson
Microsoft Access MVP
"Geoff" <gf****@freenetname.co.uk> wrote in message
news:1_********************@brightview.com...
I am interested in the field "Books_out" on Frm_Members. When the
Frm_Members loads a recordcount is performed on the recordset to determine
the total number of books out on loan. This is displayed in an unbound
text box on the form. No problems.
What I don't understand is what event to use when a new record is added to
Frm_Members so that my text box can be updated. I am using the navigation
bar to add a new record and don't know what event to use and what object
to link it to.