odd update

  • Thread starter Thread starter jw
  • Start date Start date
J

jw

Hi,

I have a database with about 10 forms. The most recently
created form updates the following record in an oddd way.

All my forms that function well are set to Data Entry and
Continuous Forms. I have several fields that are combo
boxes and some of these I have set to carry the value
from the current record to the upcoming record. For
example, I want to set the Year one time and then leave
it on for many records.

The odd form has no code in the On Update event, yet it
updates the following record. Worse yet, when I go to
the next record and change the value, ALL records change
to the most recently selected value.

This is very odd. I think I originally created this form
and the base table corresponding by copying and modifying
another similar table. I thought the new table or form
might be somehow contaminated by the original similar
table/form so I deleted the new base table, 1 query that
fed a field in the form and the form. I recreated the
table, query and form and the problem remains.

Can anyone help me figure out what is going on? Thank
you in advance!
 
My guess is that the combo box in which you see this behavior is not bound
to a field. An unbound control in a continuous forms view will show the same
value for all records.
 
jw said:
Hi,

I have a database with about 10 forms. The most recently
created form updates the following record in an oddd way.

All my forms that function well are set to Data Entry and
Continuous Forms. I have several fields that are combo
boxes and some of these I have set to carry the value
from the current record to the upcoming record. For
example, I want to set the Year one time and then leave
it on for many records.

The odd form has no code in the On Update event, yet it
updates the following record. Worse yet, when I go to
the next record and change the value, ALL records change
to the most recently selected value.

This is very odd. I think I originally created this form
and the base table corresponding by copying and modifying
another similar table. I thought the new table or form
might be somehow contaminated by the original similar
table/form so I deleted the new base table, 1 query that
fed a field in the form and the form. I recreated the
table, query and form and the problem remains.

Can anyone help me figure out what is going on? Thank
you in advance!
Click to expand...

It sounds to me as though the control you are updating is unbound.
Check its ControlSource property, and make sure it's not blank, and is
set to the name of a field in the form's recordsource table.
 
Thank you for helping me save my database! You are
completely correct! I checked the ControlSource property
and it is blank! I checked a properly functioning form
and the ControlSource property is filled in with the
correct name of the field from the base table.

Your answer helped me figure out how I had caused this.
I am so glad you could diagnose the problem by looking at
the symptom. In the combo box wizard I had
selected "Store this value in this field", but I forgot
to name the field in the box to the right. I have been
doing this for a while and I thought I could not have
made a mistake, and that Access must be corrupting my
datbase. I am releived that it was just operator error!
 
Hi,

Thank you for your response! If you read the above
answer to Dirk Goldgar you will see how grateful I am to
get the hint that let me solve this problem. Thank you!
This newsgroup has helped me learn so much and be able to
do so much with Access as well as helping me out of a
problem like this one!
 
Back
Top