If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Disappearing data in sub-form
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? |
#2
|
|||
|
|||
Disappearing data in sub-form
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? |
#3
|
|||
|
|||
Disappearing data in sub-form
On Tue, 25 Aug 2009 21:30:01 -0700, 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? 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? -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Disappearing data in sub-form
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? |
#5
|
|||
|
|||
Disappearing data in sub-form
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. "John W. Vinson" wrote: On Tue, 25 Aug 2009 21:30:01 -0700, 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? 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? -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Disappearing data in sub-form
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/ex...tors.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? |
#7
|
|||
|
|||
Disappearing data in sub-form
On Wed, 26 Aug 2009 21:38:01 -0700, charlesandmarcie
wrote: 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. -- John W. Vinson [MVP] |
#8
|
|||
|
|||
Disappearing data in sub-form
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! "Tom Wickerath" wrote: 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/ex...tors.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? |
#9
|
|||
|
|||
Disappearing data in sub-form
The front end of our database was indeed corrput. Thanks to Tom and John for
all the help. "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? |
Thread Tools | |
Display Modes | |
|
|