RE: Disappearing data in sub-form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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/
__________________________________________

"charlesandmarcie" wrote:

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.
__________________________________________

"Tom Wickerath" wrote:

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/
__________________________________________

"charlesandmarcie" wrote:

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?
.

Relevant Pages

  • RE: Disappearing data in sub-form
    ... The sub-form is not based on a query. ... Are you receiving any error messages, or do you see any status bar ... If the subform is based on a query, is the query updateable and can you ... box is likely unbound (ie. it has no Control Source specified). ...
    (microsoft.public.access.forms)
  • Re: Total in a subform
    ... subform is a text box named txtWorkHours which uses as a control source a calculated field in the query. ... In the footer of the subform, I've added an unbound text box. ...
    (microsoft.public.access.forms)
  • Re: Help! Report Printing Multiple Records from Subform
    ... I will write another query for the report and have the control source just ... Normally a main form is bound to one table, and the subform ...
    (microsoft.public.access.reports)
  • Re: #Name? - Killing Me
    ... In this case I think the Control Source expression was at fault in that it pointed to something Access couldn't identify. ... However, if the fields are available on the form then they are part of the record source, so in that sense it is accurate to say the field was not in the query. ... form and subform are not linked properly. ... calculations work correctly in the query. ...
    (microsoft.public.access.forms)
  • Re: setting textbox value
    ... > For some reason I'm having troubles changing the text value of a textbox. ... the textbox equal to the results that come back from this query. ... control source looks something like the following: ... in a subform. ...
    (microsoft.public.access.formscoding)