combo box changes all records in all forms

[Kerrin]

Hi,

I'm fairly new to Access, and have built a database to record advertiser
contact details, orders etc. It is a very simple one, with no coding that
hasn't been created by a wizard, and it will be having several thousand
businesses in it.

I have created a combo box (an add-in after i initially created the form)
called section - this was done through a wizard, and looks up values in a two
column table. This is integral to filter forms effectively. Everything is
fine, except when i change the record on one form it changes every other form
in the database to the same value. Don't know how to fix this - Any help
would be greatly appreciated.

Cheers.

 

[Nikos Yannacopoulos]

Kerrin,

You seem somewhat unclear, so let's first set this straight: forms do
not store data, data is stored in tables. Forms allow you to display,
change and add new data from/into the table(s) that they are bound to.
So, if you have several forms that are bound to the same table(s),
changing data through one of them stores the changes in the underlying
table(s), and any other form bound to the same table(s) will reflect the
changes.

Now, to your actual problem, my best guess - based on the limited info
provided - is that you have made your combo box bound to a table field,
so it stores whatever change you make to it, to the current record
displayed on the form at the time of the change. Being meant to filter
the form, the combo should actually be unbound, so it doesn't save
anything anywhere! Open your form in design view, right-click on the
combo and display its properties; go to tab Data and see if there is a
field name in the top property, Control Source. If my guess is correct,
you will indeed find a field name there (the one to which the unwanted
changes are made); delete it, leaving the property blank (so you make
the control unbound), and your problem is solved.

HTH,
Nikos