Edit existing fields when creating Microsoft Access Form

[redsquad3]

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





I created the form from this table

[davegri]

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.

[June7]

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.

[ArviLaanemets]

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.

[redsquad3]

Thank you, I will look into that and reply if it's working

[redsquad3]

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

[June7]

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 & "'"