Access 2000/XP. All I'm trying to do is create a record definition containing a field that creates itself as an exact duplicate of one that is entered previously in the SAME record (as the record is saved - no need to display it). A simple calc or constant field, or macro, I would have thought ... but how's it done in Access?
A little more info please. Is this a table, where you want a copy field to be populated every time you change the value in another field? Or is the information coming from an Access form and you simply want to populate the field in the table?
It's for a web form feeding an Access back end. The user enters a description of, for example, a 'category' field of his choosing and submits this. This description is part of a table of descriptions that goes on to populate a drop-down/combo menu for other users to search all records by.
The SQL component of subsequent searches from this combo menu however needs to take its actual value from a separate value field which in the case of all non-control records ('All', etc) is exactly the same as that entered originally. Hence the needs for for the duplicated field.
At the moment the new categories are entered twice, once for the decription field and then copied exactly and pasted into the second (value) field.
You can see the purpose of the end result at this work-in-progress site
Thanks - of course this is the 'proper' way to do it from the input side of things (web form) - and I'd lost sight of this !!!!
But I had assumed creating the extra field info wouldn't be a problem on the database side of things as the record was saved!
(In at least one database proggy of my long distant past experience - Superbase - it was easily possible to create any manner of fields -virtual or real - created on the fly from an existing field in the SAME record. Calc or constant fields I think.)