Results 1 to 7 of 7
  1. #1
    redsquad3 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2018
    Posts
    4

    Edit existing fields when creating Microsoft Access Form

    Everytime I change what equipment or module I want to use in the existing part of the form, it also changes in the new part of the form. I was wondering how I would be able to unlink the two so as to make changes to one part of the form without the other part of the form changing
    Click image for larger version. 

Name:	Capture.jpg 
Views:	15 
Size:	98.7 KB 
ID:	34075




    I created the form from this table

    Click image for larger version. 

Name:	Capture2.jpg 
Views:	15 
Size:	39.1 KB 
ID:	34076

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,740
    It looks like NEW and EXISTING sections of the form are simply duplicate controls, displaying the exact same data.
    Maybe you could tell us what you are trying to accomplish with the form and we can make suggestions.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Well, if two controls are bound to same field, changing one will change the other.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    Join Date
    Apr 2017
    Posts
    1,792
    Either
    1. use continuous form or single form, where you create a new record (all fields are empty at start) and then edit all record fields;
    2. in case you want to duplicate existing record, edit some values, and then add edited dataset as a new into table:
    - create a single main form based on your table;
    - add an single unbound form as subform to main form with controls matching with controls on main form (minus control linked with autonumeric PK field, when such is used);
    - Into main form, add a button with OnClick event filling subform controls with values from active row in main form, or with calculated values (e.g. a new PK field when this is not autonumeric);
    - Into subform or main form, add a button with OnClick event, which inserts a new record into table using values of controls in subform.

  5. #5
    redsquad3 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2018
    Posts
    4
    Thank you, I will look into that and reply if it's working

  6. #6
    redsquad3 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2018
    Posts
    4
    Hey, I'm trying to make a form where you can input an existing equipment and module and then input a new existing equipment and module, so for example lets say for the existing input I put Extractor for the equipment and M1 for the module and for the new input I want to put Extractor 2 and module M3. I want it to duplicate all the existing records on the table that have the Extractor as the equipment and the M1 as the module for the new input that I just put (which would be the Extractor 2 and the module M3) and then append the new duplicate records to the table
    Click image for larger version. 

Name:	Capture3.jpg 
Views:	14 
Size:	199.5 KB 
ID:	34085

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Requires code.

    Use UNBOUND controls to input the values.

    VBA can be like:

    CurrentDb.Execute "INSERT INTO Recipe(Recipe_Page, Equipment, Module, date_stamp, Parameter) SELECT Recipe, " & Me.tbxEquipNew & " AS E, " & Me.tbxModNew & " AS M, Date() AS D, Parameter FROM Recipe WHERE Equipment ='" & Me.tbxEquipOld & "' AND Module='" & Me.tbxModOld & "'"
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Creating Lists in microsoft access
    By mndauber in forum Access
    Replies: 4
    Last Post: 05-18-2018, 02:59 PM
  2. Replies: 7
    Last Post: 12-12-2016, 02:34 PM
  3. Replies: 29
    Last Post: 05-06-2015, 10:18 AM
  4. Edit and Existing Form
    By sdel_nevo in forum Forms
    Replies: 7
    Last Post: 09-26-2013, 02:09 AM
  5. Replies: 24
    Last Post: 09-01-2010, 02:09 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