MS Access - Linking text box and combo box

[Pankaj_kumar]

Hi,


1. How to link text box and combo box.
2. How to hide/show subform columns by clicking on checkbox in main form.
3. How to open subform filter data into excel by clicking on button.

Any help would be appriecated.

Thanks,
PK

 

[Micron]

My answers marked in red.

Hi,
1. How to link text box and combo box. Link? You mean, make textbox same as combo? In combo AfterUpdate event, Me.txtbox = Me.cmbCombo
2. How to hide/show subform columns by clicking on checkbox in main form. Me.SubformControlName.Form.ControlName.ColumnWidth = 0 (or any +ve number)
3. How to open subform filter data into excel by clicking on button. Vague question. Use Excel to pull in the data? Use another thread with more info for this one.
Any help would be appriecated.
Thanks,
PK