Mirroring Field Details

S

spleewars

Registered User.
Local time
Yesterday, 21:23
Joined
Jan 28, 2011
Messages
28
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
 
Try;
Code: 
= [Y]
As the Control Source for Field X
 
Last edited:
John Big Booty said:
Try;
Code: 
= [Y]
As the Control Source for Field X
Click to expand...

Hi John, 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
 
Calculations generally should not be stored in tables. Tables are for raw data. The calculations can be pulled from the data at any time using queries and reports. Do not confuse data base tables with Spreadsheets. They are not the same. Look at the link in my signature for DataBase Principles. It is a very good white paper.

Alan
 
You must log in or register to reply here.

Similar threads

A
Counting specific numbers in textbox of two or more rows , (no duplicates)
Replies
12
Views
611
CJ_London
C
F
Separating field data with special criteria
Replies
2
Views
271
CJ_London
C
Uncle Gizmo
Ollama Mistral - A-level Maths
Replies
0
Views
187
Uncle Gizmo
Uncle Gizmo
J
Unable to delete record due to record lock
Replies
6
Views
415
The_Doc_Man
The_Doc_Man
C
Inventory- hold stock level or not
Replies
11
Views
273
The_Doc_Man
The_Doc_Man

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom