Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2020
    Posts
    21

    Data entry problem when using a subform within a main form

    I'm trying to enter data using a subform in a main form. One form has two subforms. Each subform manages data from different tables.
    But when I try to touch the data in the field, the subform fields start to float on the screen and their data and header images start to disappear.


    It didn't happen before and something has changed in my computer.


    Perhaps the problem is lack of memory. If so, how can I manage memory using MS Access system tools?


    Thank you for your attention. Hope to get any suggestions to solve the problem.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Look for any Updates recently, Access or Windows.
    Rollback if any found and see if that corrects the issue.
    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
    Join Date
    Sep 2020
    Posts
    21
    Hello, Welshgasman,
    First of all, thanks a lot for your answer! My hope that someone would listen to my problem was fulfilled!


    Following your advice, I searched for the latest updates for Access and Windows in an attempt to resolve computer system issues and downloaded them.
    There was no change in the behavior of the form.


    The last time I didn't mention that a query was used as the source for the subform.
    This was an attempt to use a query as a source for the subform instead of the originally defined form.

    I recently tried to define a new form that uses the same query as a source and used that form as the source in the subform.
    The problem didn't reoccur: data and header images didn't disappear, and data updates were accepted.


    Now, if using a form instead of a query as the source for the subform, is the answer that solves the problem I need to define a new form for each subform .


    For now, I'll leave this issue open until someone explains to me that it's more acceptable to use a form instead of a query when creating the application and I will close it.

    With best regards

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    Join Date
    Sep 2020
    Posts
    21
    Hello, Gicu !

    Thanks a lot ! Appreciate your answer !

    I see that this is my problem too !

    Let's wait and I hope we will get any info that the bug was fixed.


    With best regards

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by NeedSomeHelp View Post
    Hello, Gicu !

    Thanks a lot ! Appreciate your answer !

    I see that this is my problem too !

    Let's wait and I hope we will get any info that the bug was fixed.


    With best regards
    Meant to be tomorrow?
    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

  7. #7
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Yes Paul, that's what Colin suggested in the second thread, I would be impressed with MS' speed if that's the case.....!
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  8. #8
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858

  9. #9
    Join Date
    Sep 2020
    Posts
    21
    Following your remark that the bug is should be solved on March 14, I made a run to receive last updates for MS ACCESS and continued to make a test if the problem disappeared.
    The problem is complitaly gone.
    Thanks a lot for your kind help.
    You All are doing a great job!
    With best regards

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

Similar Threads

  1. Replies: 2
    Last Post: 02-16-2022, 04:08 PM
  2. Replies: 1
    Last Post: 03-05-2020, 05:50 AM
  3. Replies: 2
    Last Post: 12-09-2015, 04:50 PM
  4. Replies: 8
    Last Post: 05-30-2013, 05:06 PM
  5. Replies: 2
    Last Post: 04-24-2013, 11:52 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