Where do I put the code?

[Wrecker]

I have a Form with several Tab Pages. I want a text box on one of the pages to hold the value from a textbox on another tab page. Example: me.FWLF2.Value = me.FWLF.value

This works fine if I place the code in a Lost focus event of a text box that will have data entered into it. Where would I put the code so it works when the tab page is selected and only viewed? I tried to put it in the on Click event of the form, and the on click event of the page but it dosen't work. I also tried the before update event to the form but no luck.

Thanks
Wrecker

 

[Elysium]

What type of tab control are you using? It will make a difference.

RS

 

[Wrecker]

Not Sure of what you mean by "tab control"?

Thanks
Wrecker

 

[Transcend]

Have you tried it on the afterupdate of the textbox?

Wrecker a tab control is something you can use to present several pages of information as a single set. This is especially useful when you're working with many controls that can be sorted into two or more categories. For example, you might use a tab control on an Employees form to separate general and personal information.
Look up tab control in access for more info


Transcend

 

[Wrecker]

My form has 5 Tab Pages, with different Info on each page. Is that what you mean by "Tab Control"? I don't undersatnd what you mean by "Type" of control. I have put the code in different events in the property box for the tab page that the textbox is located in.

Thanks
Wrecker