Declaring variable equal to filter of form

[jgd12345]

This is my last problem. What's the vba code to have a command buttom open a report but with the filter being the one currently on the form that the command button is on.

This code below is what I would normally use but I need to set the variable stLinkCriteria equal to the filter for the form.

DoCmd.OpenReport stDocName, , , stLinkCriteria

 

[RoyVidar]

Hi!

See if this might fit thread703-796248.

Roy-Vidar