Results 1 to 5 of 5
  1. #1
    Noek is offline Novice
    Windows XP Office 365
    Join Date
    Sep 2025
    Posts
    5

    Splkit form issue with saving to form

    OK hopefully I explain this correctly, I'm still new to Access. I have created a table to store records entered from a form. Everything works great. So now I want to use the split screen feature with the form to enter records on the left side and the table it gets saved to on the right so I can see the records as I enter them on the form. I have done this before, I just can't remember how I did it.



    In form properties of the form, in the format tab for default view I chose 'Split Form'. Then again in the format tab I scrolled down to Split Form Orientation and I chose 'datasheet on the right', because I like the side by side view and I can see my entries as I am entering them. When I click my submit button on the form that saves the record to the table, the entries in the split view to the right disappear. It is saved to the table, but in the split form table of the form it disappears. I just want to keep entering records in the form, seeing the entries in the split form table on the right, and its saving to then table database in the background. I know there is a way to keep it from disappearing I just can't figure out how to do it.

    Thanks in advance, Sorry for the newb question.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,571
    Is the form set as DataEntry= Yes?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Noek is offline Novice
    Windows XP Office 365
    Join Date
    Sep 2025
    Posts
    5
    Quote Originally Posted by Welshgasman View Post
    Is the form set as DataEntry= Yes?
    Yes sir it is, but I have a feeling its something small like that I am overlooking

  4. #4
    Noek is offline Novice
    Windows XP Office 365
    Join Date
    Sep 2025
    Posts
    5
    Think I might have figured it out, data entry needs to be set to 'no'. If set to 'yes' it means you can only enter new data, but not view previously entered data :/

  5. #5
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 11 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,205
    Correct. Its a badly named property that can cause confusion
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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

Similar Threads

  1. Permissions Issue? OLD Version, MDW Issue?
    By Billerica Tech in forum Access
    Replies: 13
    Last Post: 02-27-2021, 09:30 AM
  2. Replies: 3
    Last Post: 04-22-2015, 04:35 AM
  3. Replies: 5
    Last Post: 01-08-2015, 02:08 PM
  4. CDate and CStr issue with "Invalid Use of Null" Issue
    By excellenthelp in forum Queries
    Replies: 3
    Last Post: 07-25-2014, 01:34 PM
  5. Replies: 22
    Last Post: 05-21-2013, 07:54 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