razarsharp
Programmer
Access 97:
1. How would I use a button(or similar) to duplicate various field data on a form into a separate record?
2. And in that duplication, updating a piece of a field?(ex. 2000-1-01 to be 2000-1-02)
3. And in updating that field, how can a change that piece to reflect what was entered in another field?
(ex. if field1 = yearly then 2000-1-01 changes to 2000-1-02 and carries all the other info on the form unchanged, or if field1 = every other year then 2000-1-01 changes to 2000-1-03 and carries all the other info on the form unchanged, or finally if field1 = every third year then 2000-1-01 changes to 2000-1-04 and carries all the other info on the form unchanged)
1. How would I use a button(or similar) to duplicate various field data on a form into a separate record?
2. And in that duplication, updating a piece of a field?(ex. 2000-1-01 to be 2000-1-02)
3. And in updating that field, how can a change that piece to reflect what was entered in another field?
(ex. if field1 = yearly then 2000-1-01 changes to 2000-1-02 and carries all the other info on the form unchanged, or if field1 = every other year then 2000-1-01 changes to 2000-1-03 and carries all the other info on the form unchanged, or finally if field1 = every third year then 2000-1-01 changes to 2000-1-04 and carries all the other info on the form unchanged)