Results 1 to 4 of 4
  1. #1
    tfa is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    2

    Last entered data to show on a form after closing and reopening

    Hi All,

    I have created one form that has many text boxes and combo boxes that are recording data to different tables. The form I created details production capacity information for many machines. In the background I have a table for each machine.



    The form shows the information entered for each machine. My problem is that when I close the form and reopen the data on screen is gone. Is there any way that when I reopen the form that the last entered data remains in the form

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    the answer is probably yes - - but the implementation depends on how you've structured your data & forms, which isn't clear from your post.

    particularly unclear is the "recording data to different tables" - are these all subforms contained in an unbound main form?

    in regard to opening the forms to new data - - there is a form property that controls this - is it set to New Data?

    Not sure this helps.

  3. #3
    tfa is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    2

    Last entered data to show on a form after closing and reopening

    Thanks for your reply. What I have at the moment is one form with a number of text.combo boxes. This form does not contain any sub forms. I have approx 8 tables and therefore depending on the data recorded the text/combo boxes are recording data to assigned tables. I am recording capacity information for a number of machines. I set up a table for each machine!! Do I need to set up sub forms for each machine within the form ? ? You mention "New Data" where do I see this property ?

    Thanks again for your help

    Tom.

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    I tend to think that the better approach would be to use subforms rather than comboboxes.

    Try a couple in a new quick test form and see.

    Hope it helps.

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

Similar Threads

  1. Replies: 3
    Last Post: 05-26-2011, 12:52 PM
  2. Show related data on a form
    By Accessgrasshopper in forum Forms
    Replies: 4
    Last Post: 03-17-2011, 07:53 PM
  3. Can't get new field to show in my data entry form
    By Suzie in forum Database Design
    Replies: 19
    Last Post: 12-21-2009, 03:48 PM
  4. Replies: 9
    Last Post: 03-24-2009, 09:19 PM
  5. Unmatched data entered with data in table
    By boreda in forum Access
    Replies: 0
    Last Post: 07-28-2006, 09:11 AM

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