setting controls equal to one another

[arage]

Hi,
I would like to set the value of one bound control equal to another bound control, what is the expression format as I’ve tried several things & can’t do it yet.

Meaning on my tab control form, when user enters event form region code as 1000, then on the 2nd tab, the cpr region code shud be 1000 also.

Both region codes are fields in separate tables. Any help wud be appreciated.
Thanks!

 

[Sorrells]

If your form is based on a query that relates two tables then I'd wonder if you can update them, regardless; I have the darnest time in that situation!

This may not be what you are looking for, but we make assignments to other controls in a form based on what a user may do in a specific control.

If your textboxs are named txtRegion1 and txtRegion2, then behind the txtRegion1, most likely on the AfterUpdate event (you may have to experiment with others) try some code like this:

txtRegion2 = txtRegion1

You may want to remove the tabstop if you are now providing the data for this control.

txtregion2.tabstop = False

so the user can just zip on past this control.

Note that if your action is based on specific data entered into txtregion1 you can use an IF statement on the data entered to decide what to do.

IF txtRegion1 = "1000" then
txtRegion2 = txtRegion1
Else
'do nothing
End If

Regards, Sorrells