Re: combo box changes all records in all forms
- From: Nikos Yannacopoulos <nyannacoREMOVETHIS@xxxxxxxxx>
- Date: Wed, 18 Oct 2006 10:01:43 +0300
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
.
- Prev by Date: Re: Syntax Error please help!
- Next by Date: Re: Form Event confusion
- Previous by thread: Re: New Records
- Next by thread: Re: Form Event confusion
- Index(es):
Relevant Pages
|
