Results 1 to 3 of 3
  1. #1
    sdoyle7798 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    2

    Automatically repeating tables within a form


    How do you make a table automatically repeat within a form. We have a Access-based program for keeping a daily log in our office (Tac10, formerly SMART System). The daily log form has a table, which has a place to enter times, type of call, location, and notes. Once we start entering information into the table, a blank table will show up underneath that, ready for the next entry of the day. I need to figure out how to make that kind of automatic repetition of a table happen. Thank you in advance.

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    Data entry is done through forms. use the form wizard to create one using the table that you have mentioned. The form has navigation buttons which will help you to open a new entry form u click on it.

  3. #3
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    If you mean how do you have a value that once it's entered into a field on the form become the default value for that field for new records, you could use code like:

    me.MyFieldName.defaultvalue = "=" & me.MyFieldName.value

    and put this code in the Afterupdate event of the field.

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

Similar Threads

  1. Repeating Records
    By windwardmi in forum Reports
    Replies: 13
    Last Post: 05-22-2010, 02:54 PM
  2. Replies: 3
    Last Post: 04-22-2010, 08:52 PM
  3. Automatically filling out a form
    By thorpef1 in forum Access
    Replies: 11
    Last Post: 01-04-2010, 07:20 AM
  4. resolving repeating entries in sub form
    By cvgope in forum Forms
    Replies: 0
    Last Post: 10-07-2009, 11:14 PM
  5. Replies: 0
    Last Post: 11-10-2008, 12:32 PM

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