add records to database and more records are being entered

hello I have a database attached: when I add records to listbox and then add to database- for some reason - more records are appearing in database- if you just add one- i think it works right- but if you add more- than alot of records show up- can you see my problem- thank you
data.mdb
davetoughAsked:
Who is Participating?
 
GRayLCommented:
In click event   cmdAddtoDatabase_Click()

Change:

Do Until x = Me.lstIds.ListCount

to:

    Do Until x = Me.lstIds.ListCount-1

remember all these events are zero-based.

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
How do you "add records to listbox"? A Listbox is not a user-editable control.

When you upload a database, you should include EXPLICIT instructions to recreate the issue. For example, "Open FormA, click ButtonB and then enter something TextboxC".
0
 
davetoughAuthor Commented:
Thanks GRayL and yes your right LSM- i usually try to do that-not here though
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.