If i have a subform or subreport in a report how can I filter it for information that I want as opposed to just linking it to the main report. Is there anyway to define a WHERE condition in VB for the subform or report when you use DoCmd Open report or any other commands or macros?