My DB is going nuts! Help!

[Benjamin Bolduc]

Thanks for reading this post.

I'm not sure what's going. I thought I had finished an application that I have been working on for a few weeks.
It has 4 tables and 1 form
The form is based on one of the tables that is simply a list of the different products I'm keeping track of. It then has 3 subforms that are linked to it.
I have a combobox on my Main Form that selects the product, then all of its information is displayed by the 3 subforms.

It pulls up infomation just fine, but I've noticed recently that when I select something from my combobox and move the focus into any subform it creates a duplicate value of that product in the combobox list. When I select something new it duplicates that value too and then deletes the old one.
I didnt really think that was a huge problem since it showed only one duplicated product in the list, at a time. But then I noticed that my Product List in my main table was being altered and corrupted. The information in the records are being all switched around.
If I try to index that feild, It wont let me enter info into the records.

I hope some of this made sense. Does anyone have any ideas as to whats going on?

Thanks for your help!

 

[Fuga]

Sounds strange, but it sounds like you add a post when entering the subs, but I don´t see have this can be if you dont actually enter something in them.

Or maybe I´m just way off base here.

Fuga.

 

[Benjamin Bolduc]

I'm confused too. The only things I'm adding records to are the three subforms. The main forms is only for selecting the Product. Now my product list is all messed up. I found out that it hasnt been adding new records, just changing the [Name] feild on the ones I have. So I have 3 things in my list with the same name but different information associated with it.

I hope someone can figure this out. This DB is really important and I'm going to look like an idiot if I mess it up

 

[Benjamin Bolduc]

Woohoo!
I fixed it. It turns out I had the Combobox bound to the feild it was looking up. I changed it to unbound and now everything is working fine