Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
  1. #16
    negative_creep is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jul 2019
    Posts
    11

    Quote Originally Posted by pbaldy View Post
    Did you zip it? The limit for zip files is 2MB.
    Here try this
    Attached Files Attached Files

  2. #17
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    It's an odd method, but the reason you don't get new records is because your macro saves the record but doesn't move to a new one. The fix for the method you have is to add a new action to the macro, "GoToRecord" and specify New.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #18
    negative_creep is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jul 2019
    Posts
    11
    Quote Originally Posted by pbaldy View Post
    It's an odd method, but the reason you don't get new records is because your macro saves the record but doesn't move to a new one. The fix for the method you have is to add a new action to the macro, "GoToRecord" and specify New.
    Why is it an odd method? What would be a more preferred method?

    Thanks,

  4. #19
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Ah, maybe I was premature. I don't know the flow your users need to follow or what the actual data looks like. It seemed odd to have a combo and a button alone.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #20
    negative_creep is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jul 2019
    Posts
    11
    Quote Originally Posted by pbaldy View Post
    Ah, maybe I was premature. I don't know the flow your users need to follow or what the actual data looks like. It seemed odd to have a combo and a button alone.
    Yea I am just starting out with this project and wanted to have the basics worked out before I proceed. The form will eventually have more data for the user to choose and add to the Records table.

  6. #21
    negative_creep is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jul 2019
    Posts
    11
    Quote Originally Posted by negative_creep View Post
    Yea I am just starting out with this project and wanted to have the basics worked out before I proceed. The form will eventually have more data for the user to choose and add to the Records table.

    When I first load this form, it automatically displays the data of a previous record. How can I have this form be clear on load?

    Thank,

  7. #22
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Did you make the Data Entry property Yes?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #23
    negative_creep is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jul 2019
    Posts
    11
    Quote Originally Posted by pbaldy View Post
    Did you make the Data Entry property Yes?
    The data entry property is set to "YES"

  9. #24
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Can you attach the latest version of the db? In the sample posted earlier, the form comes up blank, as I would expect. Oh, and how is it opened? The setting may be getting overridden by an argument in OpenForm.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 11-15-2018, 12:37 PM
  2. Replies: 2
    Last Post: 05-01-2014, 06:51 PM
  3. Newbie question about Access Web Compatibility
    By mikeone610 in forum Access
    Replies: 1
    Last Post: 01-28-2014, 04:33 PM
  4. Replies: 6
    Last Post: 07-02-2013, 11:28 AM
  5. Replies: 8
    Last Post: 04-25-2012, 11:30 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