Why is my form adding records on its own

[ctpoodle]

Hi. I am perplexed. :banghead:

I start with a table of UserIDs, names and roles (tblUserIDList). I have a simple query off that which lists them in alpha order by UserID. Next I have a simple form with a combo box which uses that query to select the User and binds the UserID field to use. There is a button which triggers a macro which opens the 2nd form using a query which filters using that UserID. There is another point in that form in which that UserID is again used as a filter for other data. The 2nd form is a data input form. All works fine up to that point.

However, when the 2 forms are closed, for some reason the UserID is re-added to the tblUserIDList. I've never had this happen before.

Does anyone have any suggestions? Or does anyone see anything stupid that I've done here? I realize I haven't given a huge amount of detail but I'm hoping someone has experienced this before.

Thanks for any help!!

 

[JHB]

Could you post a stripped down version of your database with some sample data, (zip it), plus a description how to reproduce the fault you get?

 

[ctpoodle]

Sorry for the delay. Here is a stripped down version of my database. I appreciate any help. I'm sure I've included something I don't realize I've included which is making it do this.

Thanks!

 

[JHB]

You didn't give any information of that.

.. plus a description how to reproduce the fault you get?

 

[ctpoodle]

Okay, I select a User from the UserID Selection form and click on the Time Off Floor button, which opens up the Time Off Floor Activities form. When I click Exit on that form, it closes both forms. However, if you open up the tblUserIDList table, you'll note that a new record was added with the UserID and I don't know why.

 

[JHB]

The combobox cboUserID in the form "UserID Selection" need to be unbound, database attached.

 

[ctpoodle]

Thank you so so much! I knew I had done something stupid! I looked at this so many times and just did not see that! You are the best!!!

 

[JHB]

You're welcome.