:confused: How do I make a text box list the number of the last record. Umm like if I had 100 records the text box would say 100 and then if I deleted a couple it would say 98. :confused:
Thanx for at least looking at my question.
Ezz3x
Printable View
:confused: How do I make a text box list the number of the last record. Umm like if I had 100 records the text box would say 100 and then if I deleted a couple it would say 98. :confused:
Thanx for at least looking at my question.
Ezz3x
use =DCount("<field>","<source>"), you might need to requery the text box after your deletion.
VB Code:
TextBox.Text = RecordSet.RecordCount
Thank you Darre1!!!!!:D :)
welcome :)