Carrying a value to a different field on a new record

[Idjit]

I'm designing a form for entering a person's residential history, with each record recording one residence for an individual. What I'd like to do is this:

The user enters in the year a person moved from a particular location ([YrEnded]), then clicks a command button to go to a new record to enter the information for the next residence.

I want the ending year of the residence they just entered to automatically fill in as the beginning year ([YrBegan]) for the next residence. Is there a way to do this, preferably using macros rather than VB (note the nic)?

I hadn't planned on even including [YrBegan] because I saw it as a redundant field, but this will make things easier for the analysts and also allow me to include a validation so that the user can't enter an ending year that is earlier than the beginning year.

 

[casey]

Sorry that wont work

...

 

[Idjit]

Well Jack,

Despite the fact that the first sentence I saw in the article you sent was "Advanced: Requires expert coding, interoperability, and multiuser skills.", I will indeed try what you suggest.

Thanks a bunch, it looks like just what I'm looking for.

 

[Jack Cowley]

I got to thinking about my post and decided that that article was not the best one so in my haste to update it I deleted the whole thing.... Oops...

Take a look here as this article may be more appropriate for you. It will require a bit of modification as you want to get data from one field and put it into another. The previous article I posted was basically for a form to 'view' the data so I think this approach is really what you want.

Sorry about the deleted message...

Jack

 

[Idjit]

No problem. I think you're right - this second article's approach looks like it will be easier for me to implement.

Thanks again!

 

[Jack Cowley]

You are welcome. Good luck with your project....

Jack