Forms

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

Guest

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.
 
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]
 
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...
 
Back
Top