Display main table data on subform

[scottshiv]

My form has three tabs for the main table and the two linked tables. All you can see at any one time is the data for the selected tab.

I would like to display the customer ID and customer name fields from the main table on each of the subforms. How do I do that?

 

[footbinc]

COuld you not just use Form notation (For lack of a better term) to do this?

How about (assuming its a textbox on your subform)

me.txtbox = Forms!frm_MAINFORM!TxtValueYouWant

You could also set the control source of the text box on the subs to that. Try that.