Results 1 to 2 of 2
  1. #1
    pnut1p3 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010

    prevent form from going blank after closing

    Hi I'm relatively new to access and had a question about how to redisplay the data entered into a form after closing it. I'm using Access 2007.

    My DB is split, with the FE containing an input form, frmPMData (where project managers will input the data they need to track), and BE containing 4 tables which store the information supplied by the project managers. I plan to make the FE frmPMData an .accde file once I'm done designing the DB. The DB will eventually be stored on a shared network drive and the project managers will access it there. Currently it is saved to my hard drive.

    I want the project managers (who are not familiar with access) to be able to enter and edit data for their projects only via the FE frmPMData. My reason for doing this is to make the process very user friendly for the project managers. However, I've noticed that after I'm done entering data and I close the form the next time I open it all the records disappear (the form starts on record 1 of 1). The issue is not that the data isn't being stored in the tables; but that the records are disappearing from the form since this will be the only place the project managers can view/edit their data. Is there anyway to prevent this from happening so that the project managers can go back into frmPMData and view/edit the records/data they previously entered?

    I've looked on a bunch of forums on different sites and haven't had any luck finding an answer. Any and all help would be greatly appreciated. Let me know if you are confused or if I need to elaborate on the description of my problem/DB.


  2. #2
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Dayton, OH
    Open the form in design view then go to the property sheet-->Data and look for the Data Entry property. If it is set to Yes it will open ready for a new record (i.e. you will not see previously entered records). Change the property to No to see all records when the form opens.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to open a blank form?
    By WhatnThe in forum Access
    Replies: 15
    Last Post: 08-05-2011, 02:41 PM
  2. I want my form to open blank
    By uneek78 in forum Forms
    Replies: 10
    Last Post: 01-12-2011, 01:01 PM
  3. Closing a Form Problem
    By MuskokaMad in forum Forms
    Replies: 2
    Last Post: 03-18-2010, 05:58 AM
  4. Replies: 2
    Last Post: 03-14-2010, 08:21 AM
  5. Replies: 9
    Last Post: 12-28-2009, 04:01 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums