TextBox Controls

[FREDDY67]

Afternoon

I have a textbox on the main form that is contolled from by selecting a record on subform1 it in turn it controls what data is visible on subform2. Is it possible to also control the textbox by selecting a record on subform3, in other words can a textbox have 2 control sources & just use which source was selected last, if this is possible how do I go about it?


Thanks

Freddy

 

[FREDDY67]

Sorted

I added some timestamp textboxes with diffrerent defaults to the subforms & then controlled the mainform textbox by the highest timestamp, thereby controlling the mainform textbox from 3 sources. It may not be the perfect way but it works just fine.

Thanks

Freddy