Variable of Number of Records in Forms

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

Guest

I am doing forms for an office that have people who need large buttons. I
don't wish to use the navigation buttons because of the "add record" button
and they accidently hit it when trying to move to the last record.

So saying, I would still like to have the information as to the number of
records when the sub form has been filtered. I have not been able to find a
reference to a variable that contains this info, but obviously there must be
since it is displayed when the navigation buttons are used.

Thanks,
John H W
 
Dear John H W:

I can think of a few suggestions, (others may have better ones!<g>):

1. Set the "Allow Additions" property of the form to "No". This will cause
the "Add Record" button to be disabled, but preserve the functionality of
the rest of the built in navigation bar.

2. You might want to disable the built-in navigation buttons and implement
your own custom navigation buttons. An easy solution exists at
www.lebans.com. Go to the following link for a ready-made solution you can
just drop into your form and modify to meet your own requirements...

http://www.lebans.com/recnavbuttons.htm

HTH
Fred Boer
 
Fred:

Suggestion 1 will not allow adding records even with a command button.

Suggestion 2 is what I had done, but wanted to let the user know how many
"filtered" records there were.

I did find a way using RecordSetClone (See the reply to "Count the number of
records in a form?" below).

Thanks,
John H W
 
Back
Top