Sub form problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a Continuous sub Form and I would like to do a couple
things that I am not sure I can.

First I would like to somehow display the number of instances of the form
that are generated and on each instance which of those it is. In otherwords
I would like to set up a text box or something in the fower corner of the
form that would say "1 of 2" "2 of 2" etc.

What I am doing, to make sure I am providing enough information is I have a
main form that has a table as a record source. That table has a one to many
relationship with another. I have a sub form on the main that returns all
associated related records from the second table, allowing the addition of
other.

Was wondering if there was an easy way to accomplish the above.

Thanks in advance!
 
Close but no. It is a Continuous sub Form. It works, but the info is only
correct for the record that currently has focus. Any was I can make this
acurate regaurless of the record that has focus? So that even if I am "ON"
"New Record" Record 4 of 4 STILL INDICATES Record 4 of 4.
 
Try this:

=IIf([ID]="New","New Record",[Forms]![FormName].[CurrentRecord] & " of
" & Count([ID]) & " records")

Make sure that the default value for [ID] is set to "New"
Replace [FormName] with your form name and [ID] with yours.

Hope this helps.
 
Back
Top