Record count on different Form

[channell]

Hello,

I have a continuous(forms) subform with fields and buttons. There is a
blank field with a button next to it. If I press the button, another form
pops up and I can enter information. When I close the pop-up form, I need to
have this blank field display the number of records on the pop-up form.

Is this Possible? I truly appreciate all the help rendered by the many
great people in this group. Thank you so very much for your time and efforts!

-Scott Channell

 

[BruceM]

Tables and queries have fields. Forms and reports have text boxes and other
controls that can be bound to fields.

If the pop-up form is bound to a recordset you can use DCount to count the
number of records in that recordset. Help has more information about
DCount. In general an unbound text box can have a Control Source something
like:
=DCount("*","[TableName]")

You can use criteria to limit the count to records matching the criteria.
For instance, if the record has a date field you can limit the record count
to records before a particular date.

 

[channell]

Ok Ok, I will work with that. Thank you Bruce.

I apologize for not being as specific as I should have (I do have a problem
with that).

Alright, this field that I need populated is an already existing field in a
table. It is to keep track of occurences of an event. Normally, I would
just enter a number in and it would be fine. However, we needed a bit more
information to go along with just a number (hence the pop up form). Now, I
was wanting to auto-populate this field with the number of records on a
particular workday from the pop-up form.

I hope this makes more sense. I will still work with what you gave me,
which I greatly appreciate!

-Scott Channell

Tables and queries have fields. Forms and reports have text boxes and other
controls that can be bound to fields.

If the pop-up form is bound to a recordset you can use DCount to count the
number of records in that recordset. Help has more information about
DCount. In general an unbound text box can have a Control Source something
like:
=DCount("*","[TableName]")

You can use criteria to limit the count to records matching the criteria.
For instance, if the record has a date field you can limit the record count
to records before a particular date.

Hello,

I have a continuous(forms) subform with fields and buttons. There is a
blank field with a button next to it. If I press the button, another form
pops up and I can enter information. When I close the pop-up form, I need
to
have this blank field display the number of records on the pop-up form.

Is this Possible? I truly appreciate all the help rendered by the many
great people in this group. Thank you so very much for your time and
efforts!

-Scott Channell