 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / March 2007Forma and Disappearing records
This is strange and I cannot for the life of me figure it out. A table full of records and a form using the table as the record set. A user did something and now when opening the form, none of the records show even though they are in the table. Can anyone throw out an idea??? Thank you  SignatureJeff C Live Well .. Be Happy In All You Do If the source for the form is a query then check it for results. Open the form in design view and click on menu VIEW - Properties. Verify the Record Source. Was a filter added? SignatureKARL DEWEY Build a little - Test a little > This is strange and I cannot for the life of me figure it out. > [quoted text clipped - 4 lines] > > Can anyone throw out an idea??? Thank you Form is using a table for the record source, opening the table shows all records preseent. Open the form, verify the record source, no records visible SignatureJeff C Live Well .. Be Happy In All You Do > If the source for the form is a query then check it for results. Open the > form in design view and click on menu VIEW - Properties. Verify the Record [quoted text clipped - 9 lines] > > > > Can anyone throw out an idea??? Thank you > This is strange and I cannot for the life of me figure it out. > [quoted text clipped - 4 lines] > > Can anyone throw out an idea??? Thank you Did the user maybe set the form's Data Entry property to Yes? Check the Data tab of the form's property sheet in design view. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) Data entry is set to yes, this should be no?? SignatureJeff C Live Well .. Be Happy In All You Do > > This is strange and I cannot for the life of me figure it out. > > [quoted text clipped - 7 lines] > Did the user maybe set the form's Data Entry property to Yes? Check the > Data tab of the form's property sheet in design view. > Data entry is set to yes, this should be no?? That setting should be No, if you want to see any existing records on the form. The Datra Entry property marks the form as being for data entry *only*, meaning that no existing records are shown. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) It should be No unless the form is ONLY to be used to create new records. SignatureKARL DEWEY Build a little - Test a little > Data entry is set to yes, this should be no?? > [quoted text clipped - 9 lines] > > Did the user maybe set the form's Data Entry property to Yes? Check the > > Data tab of the form's property sheet in design view. Thank you both, I am having a stupid moment, I appreciate your help SignatureJeff C Live Well .. Be Happy In All You Do > It should be No unless the form is ONLY to be used to create new records. > [quoted text clipped - 11 lines] > > > Did the user maybe set the form's Data Entry property to Yes? Check the > > > Data tab of the form's property sheet in design view. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.