Filter Command Button Code 1

[pbundrant]

Hello,

Can someone give me the exact code for the On Click event for my command button?

I have a...

Main form: frmDelegatedOwner
Subform: frmMDRFilteredsub
Command Button: cmdFilterOn
Unbound Combobox: cboDelegatedOwner

I need the records in the subform filtered, when the button is clicked, by the name selected in the combobox.

Or a better way suggestion would be greatly appreciated.

TYIA,

Patty

 

[dhookom]

If you set the Link Master and Link Child properties you won't need any code. Otherwise your code will depend on the name and data type of the field on the subform that matches the value from the combo box.

Duane
Hook'D on Access
MS Access MVP

 

[pbundrant]

Goodness, it's been so long since I built a database I've forgotten the simplest things.
Thank you so much Duane!!

...of course it worked perfect

Patty