Disappearing data in sub-form

[charlesandmarcie]

Hope someone can help. We have a database that has many forms and subforms
that feed data to tables...in one of the subforms, after we input data into a
field and tab to the next field that data just dissapears and is not getting
saved back to the table(s). Any ideas?

 

[Tom Wickerath]

Is this happening in just the one field in this subform, or all fields in a
record in the subform? If it is happening in only one field, then the text
box is likely unbound (ie. it has no Control Source specified). The intended
target field in the table should be specified as the Control Source for this
text box.

If you cannot save any data in the record, including in other fields, then
perhaps you are missing a primary key in the recordset for this subform
(especially if it is anything other than an Autonumber data type). Are you
receiving any error messages, or do you see any status bar messages in the
lower left corner of your screen when you attempt to add data and then
navigate to a new record? If the subform is based on a query, is the query
updateable and can you add a new record using the query?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[John W. Vinson]

Hope someone can help. We have a database that has many forms and subforms
that feed data to tables...in one of the subforms, after we input data into a
field and tab to the next field that data just dissapears and is not getting
saved back to the table(s). Any ideas?

Correct the error in the form's properties.

For help doing so please describe those properties. Is its Data Entry property
set to Yes? If so you'll be able to enter new records, they'll end up in the
table, but you won't see them on the form the next time you open it. What is
the form's Recordsource? Is it the table you expect - or is it blank (making
this an umbound form)? What is the Control Source of the field that's
disappearing?

 

[charlesandmarcie]

Thanks Tom for the feedback. It is just happening in one field of the
subform, the text box is bound to a control source. We have been using this
form for sometime and all of a sudden it will blank out whatever data you
input...and there is also a default value that would populate with each new
record, that is also disappearing.

 

[charlesandmarcie]

Data entry is se tto no. the record source is a table (the one we want the
data in). Control source is the coulmn in the table we want the data in. I
should also point out that nothing (that we are aware of) has changed for a
number of years...then all of a sudden we are seeing this happen. Enter data
as we always have, then it disappears.

 

[Tom Wickerath]

Can you provide answers to the other questions I asked?

1.) Are you receiving any error messages, or do you see any status bar
messages in the lower left corner of your screen when you attempt to add data
and then navigate to a new record?

2.) If the subform is based on a query, is the query updateable and can you
add a new record using the query?

I have also read your reply to John Vinson, where you indicated that this
problem just started up, after having had no such issue in the past. That
kind of sounds like it might be corruption of some kind, perhaps form (or
control) corruption, or corruption of an index in the underlying table. I
would be interested in seeing a sample of this database, if you can send me a
compacted and zipped copy that has any sensitive data removed. If this sounds
do-able, you can find an e-mail address for me at the bottom of this page
(scroll down past the two pictures):

http://www.access.qbuilt.com/html/expert_contributors.html#TomW


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

Thanks Tom for the feedback. It is just happening in one field of the
subform, the text box is bound to a control source. We have been using this
form for sometime and all of a sudden it will blank out whatever data you
input...and there is also a default value that would populate with each new
record, that is also disappearing.

__________________________________________

 

[John W. Vinson]

Data entry is se tto no. the record source is a table (the one we want the
data in). Control source is the coulmn in the table we want the data in. I
should also point out that nothing (that we are aware of) has changed for a
number of years...then all of a sudden we are seeing this happen. Enter data
as we always have, then it disappears.

Sounds like a corrupt database. I HOPE YOU HAVE GOOD BACKUPS!

See http://www.granite.ab.ca/access/corruptmdbs.htm for causes, treatment and
cautions about corruption. You may be able to salvage this... if you've been
kind to small animals, given charity appropriately and accumulated a stock of
good karma.

 

[charlesandmarcie]

1) No error message.
2) The sub-form is not based on a query.

I'll try and send a compacted stripped down version this evening.
Thanks!

 

[charlesandmarcie]

The front end of our database was indeed corrput. Thanks to Tom and John for
all the help.