How do I stop field content repeating on every form?

[Guest]

I have about 8000 database entries. I access them as Forms which have
several fields. I have a couple of fields which I never used. I noticed
today that if I put information into one of these fields it repeats in all
8000 forms. I looked at its properties. It says UNBOUND. I don't know what
UNBOUND means nor if it has anything to do with the problem. I haven't
changed it because I am reluctant to risk messing up my database.
Thanks
Don

 

[Steve Schapel]

Don,

An unbound control on a form means that the control is not related to a
field in the form's record source table/query. Yes, if you enter some
data into such a comntrol, this will be displayed for each record of the
form, but when the form is closed, any such "data" is not stored
anywhere and is lost. I am not sure what the purpose of these controls
would be, nor do I really know why it is a "problem". I suppose if the
controls serve no purpose, they can be deleted from the form. I guess
if no-one knows what their purpose is, that is more or less the same as
them not having a purpose. In my experience, the most common reasons
for unbound controls on forms for the entry of query criteria or search
criteria, or for the display of calculated values (which would not
appear to be the case here). I take it they do not have anything
entered in their Control Source property? Have a look at the other
Properties of the controls. Do any of the event properties have the
name of a macro, or else [Event Procedure], entered in there. If so,
this may give a clue to why they are there. Another possiblility, I
suppose, is that there are fields in the form's underlying table/query
that were originally represented on the form in bound controls, but the
Control Source of these bound controls has been accidentally removed.