Mirroring Field Details

[spleewars]

Table 'Products' consists of 6 fields 'A,B,C,D,E,X'




---------------------------------


Field A,B,C,D,E are user input fields


Field Y (not bound to the table) is locked and sums together fields A,B,C,D,E


My question:


Field X is A locked field but needs to be automatically be filled with the same value (mirrored) of field Y... how do i do this?


... guys please?
Clara

[alansidman]

In the Control Source for Field X, type = [Field Y]

Alan

[spleewars]

In the Control Source for Field X, type = [Field Y]

Alan

Hi Alan, thanks for your reply.


However a new problem arise. Doing so i will destroy the link of 'field X' with the table (yes, in the form view the value is mirrored but table 'products' 'field X' detail is empty. I need the value to be copied from 'field Y' to 'field X' while information is auto filled in the table)


Thanks
Clara

[alansidman]

CrossPosting at http://www.access-programmers.co.uk/...d.php?t=223464

See my response at the other forum.