Update Label from Text Box

[rcdeck]

Hey all!



First of all, I apologize for having to ask this question, I know its extremely basic and I've done some searching but since I'm not all that familiar with access I'm not exactly sure the correct terminology to search for it. I have tried my best with Google and this forum but I am not coming up with anything that I think is correct, or that I can understand so I hope you can all help!

I am creating a form which I have split in half (Left|Right) and I have options on the left side such as date fields, and name fields. On the right, I would like it to be creating a sample of the output.

Example. When I update the Start Date field, on the right, I would like the Label to read "Start Date: 1/1/12 to End Date: " Then I will update the End Date on the left and the label will immediately update to "Start Date: 1/1/12 to End Date: 1/10/12"

So...
Label starts as "Start Date: to End Date: "
Pick start date shows "Start Date: 1/1/12 to End Date: "
Pick end date shows " "Start Date: 1/1/12 to End Date: 1/10/12"

Edit: Additionally, this information will all be exported to an e-mail in a table format.

Any help would be greatly appreciated. I will likely be here frequently as I am starting a few projects involving access and have them linked to sharepoint tables, so hopefully this is the right place for these questions!

Thanks in advance,

Rob

[John McMahon]

Have you looked at using events such as After Update, On Change, Lost Focus, and Exit of the input controls on the left? Code in there would update the labels on the right.

[rcdeck]

Have you looked at using events such as After Update, On Change, Lost Focus, and Exit of the input controls on the left? Code in there would update the labels on the right.

I have not but I will take a look at that now.

Thank you!