Forms

A

Arlene

Please can you help me as I trying to find a way on how to add a hundred
items into access and then when 1 item is added into the form that it will
automatically count down that their is 99 left and so on.
 
S

scubadiver

When you say items do you mean records?

Putting this into a text box in the header or footer will give you the
number of records:

=RecordsetClone.RecordCount

Maybe you can then add another unbound text box with

=100-[records]
 
A

Arlene

Hi,

Thanks for replying to my e-mail,

Thank you that was useful but what I was trying to do was if I had a hundred
pencils and you updated a record to say that one had been allocated to a
person that then would automatically leave you with 99.

scubadiver said:
When you say items do you mean records?

Putting this into a text box in the header or footer will give you the
number of records:

=RecordsetClone.RecordCount

Maybe you can then add another unbound text box with

=100-[records]


--
www.ae911truth.org



Arlene said:
Please can you help me as I trying to find a way on how to add a hundred
items into access and then when 1 item is added into the form that it will
automatically count down that their is 99 left and so on.
Click to expand...
Click to expand...
 
Top