updating one field on the result of another

[bigmac]

updating one field on the result of another, again this i can do BUT how do i get it to do this for all records? i have tried the on load property but it only updates the first record any ideas please.?

 

[rzw0wr]

please be a little more specific as to what you are wanting to do.
From where, what data and from where.
Text boxes, combo boxes?


Give us all the details you can.

Dale

 

[bigmac]

two fields same record [field1] empty [field2] has data, on which [field1] will change example [field2] has either a date before before today or after, if before then all records where this is true [field1] will show "out of date"

 

[Mihail]

Completely remove Field1 from your table.
Based on value of what actually you name Field2 you can do a computation in order to show in a form, report or query the "Out of date" message in an unbound text box or in a calculated field in the query.

Store this in your had:
If you can calculate something, do not store that "something" in your database.
If you do so, you will fully violate the main concept for the databases: the concept of NORMALIZATION.

Only for learning purpose
The answer to your question is: by using an Update Query.