count value problem

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

Guest

hI
I have a form with count of filed issue which happens to equal 5
when update issue filed would like assesment number to be count of issue + 1
so wrote
Private Sub issue_AfterUpdate()
Me.assesment_number = Me.COUNT + 1
End Sub
the problem is filed populated with 17 not 6 as required
when I added extra record so count = 6 still populated field with 17
where am I going wrong???
thanks
tina
 
Me.Count returns the number of controls on your form. Probably not what you
want.

Roger Carlson has some small sample databases at his site
www.rogersaccesslibrary.com that might explain how to create an incrementing
value.
 
Back
Top