Access 2000 subform

[Danny]

Greetings,

I have a field called NumOfApp in the main form and will be automatically field in, depending on how many applicants there are in the subform. I had 3 records in the subform and it was working fine, until I went to the table and deleted one record, compact and repaired it, but NumOf App still shows 3, where as in the subform it shows 2 records (1 of 2, 2 of 2). The following is the code I have. Please comment:

Private Sub txtCount_Change()
Forms![Applicant]![NumOfApp].Value = txtCount.Value
End Sub

Thanks,
DD

 

[Danny]

Calculations

Pat ,
Thanks for your reply,
In the main form I choose text box from the toolbox and right click on the unbound object, properties, Data tab, type in DCount () in the control source. I got #Name? error. Just to clarify, NumOfApp field is in my main form (HouseHold) and records I like to count are in a sub form (Applicants).

Thanks,
DD