Results 1 to 8 of 8
  1. #1
    spidge32 is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2021
    Posts
    58

    Filling fields on form from one sub form to another on change or update

    The form frmJobSheet3 or frmJobSheet has 2 sub forms
    Example.zip
    1.frmWindingDetailSubForm


    Fields. fldWdgNumber (Integer)
    fldWdgType (Text) (3 Char)

    2. frmTerminationData
    Fields. fldTermNo (Integer)
    fldTermType (Text) (3 Char)

    I would like to update the fields in the sub form frmTerminationData when the fields in WindingDetailSubForm are updated or changed

    Except when the fldWdgType is the type starting with I

    Thank you in advance

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Isn't this the same issue that you marked solved here?
    https://www.accessforums.net/showthr...707#post483707
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    spidge32 is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2021
    Posts
    58
    Yes, but the answer was by use of a query, I was specifically asking how to use VBA to do it. I then thought as it was a form it maybe better to post in forms, with the example database.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I'm no moderator but I'd say it's better to not do that as it's pretty much the same as cross posting. Having multiple threads for the same thing is worse than posting in the wrong forum IMO. I don't know how others search but I only use the New Posts list so it never matters what forum something is posted in beyond sometimes providing clues as to what's going on. Anyway, now others can read what's at the link if they so choose. That is something you ought to do in the future if you think a prior thread is similar/the same issu or will provide context to others. It doesn't even have to be your own thread to provide context.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Point to note. Referential integrity should be enforced between all tables.

    When I tried to do this with the majority of your tables I get the following error:-
    Attached Thumbnails Attached Thumbnails RI.JPG  
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  6. #6
    spidge32 is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2021
    Posts
    58
    I have fixed the example database referential integrity and uploaded a new ExampleRI.Zip. Can you advise how to update fields from the winding subform to the Termination subform in change or update using code.
    Thanks in advance.
    Attached Files Attached Files

  7. #7
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi
    There are still errors when trying to Enforce Referencial Integrity between Tables.

    Another problem is the in the majority of your tables you have Primary Keys set on Text Data Types.

    I would recommend that you have an Autonumber Primary Key in all of your tables.

    Another issue is that you have 12 tables dealing with Work Orders?

    Also in your "tblTransformerHdr" you have fields as shown in the attached. Each of these Columns is known as a Repeating Group.
    These should be records in a separate table and Not fields in your current table.
    Attached Thumbnails Attached Thumbnails Fields.JPG  
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  8. #8
    spidge32 is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2021
    Posts
    58
    Hi Mike, I know that the current database is not normalised and should be broken down to a lot more table. I will get to it in the future, did you say you have an answer to my original question. I will be home tonight after 8.00pm if you would like to skype.
    Cheers

    Bill

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

Similar Threads

  1. Replies: 16
    Last Post: 06-20-2021, 08:24 AM
  2. Replies: 3
    Last Post: 11-28-2015, 03:51 PM
  3. Replies: 12
    Last Post: 11-11-2014, 02:10 PM
  4. Replies: 6
    Last Post: 09-22-2013, 09:52 PM
  5. Auto filling form fields
    By adamch29 in forum Forms
    Replies: 1
    Last Post: 07-25-2007, 06:22 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