Macro to move data from one field to another in a form

[BlueHorizon]

Hi all,
Hope I'm in the right forum....
I'm looking to create a macro that will move data from one field to another field on the same form. The fields will always be the same. For example: I have a [name] field. When a person completes a task, their [name] moves from an "incomplete" to a "complete" field on the same form.

Any help would be really great!
TIA,

Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[dhookom]

I would question your setup/structure. Is there a reason you don't have a status field that you change from "incomplete" to "complete"?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[BlueHorizon]

Hi dhookom,
Great question - wish I had a better answer than that the database didn't originate with me and I'm forced to work with the structure to which everyone has become accustomed.
Thanks,

Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[dhookom]

On the form that is used to somehow enter that a task has been completed, you would add code like:

   Me.txtComplete = Me.txtIncomplete
   Me.txtIncomplete = Null

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]