vba - Controlling form with Combobox -


i have form combo box in form header populates values in form. can select different values in combo box refer observations in table, , form filter have data table observation select in combo box in form.

it works fine, when open form, form populated first row in table, though combobox blank. how set form when combobox in header blank form blank, , form populates when populate combobox?

thanks

you leave subform record source blank , in combo box afterupdate() event, change subform record source , requery subform.

this can bit sloppy since form requeries notorious unreliability. i've done in past make subform popup , in afterupdate() of combo box or on button click, modify record source , open desired subform.


Comments

Popular posts from this blog

javascript - Bootstrap Popover: iOS Safari strange behaviour -

Magento/PHP - Get phones on all members in a customer group -

session - Logging Out Using PHP -