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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Count number of rcd on continuous form. 3
Problem counting items in List Box 5
Using SQL Query Code in Form Module to Return Record Count 2
Unbound Combo Box 8
You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has a 1
How to stop Word counting Endnote reference data in word count. 0
Counting from multiple fields 7

Back
Top