var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: get data from subform
I want to show the data in the subform to another form. How to retrieve it? For example, i have country combo box in the subform. when user select one country, i want to show the value in the form. Thanks.
Are the two forms connected?
Yes,there is button called make receipt in the first form, then it will pop up another new form. I would like to retrieve the country value from subform in the first form to the new form. Thanks.
In the AfterUpdate() event of the subform, open the new form passing the value of the combobox as an OpenArgs argument, such as
Of course, you can put any other parameters you need in there as well.
DoCmd.OpenForm "NewFormNameHere", , , , , , Me.ComboBoxNameHere.Value
In the NewForm's Open event, put the following code:
Hope this helps,
Me.ControlNameHere = Me.OpenArgs