MajP, you help!!!! You helped me so much with the GetFilterFromListBox issue and now I have another issue. I am taking the results of that information and have a button where my end-user can click on it and it takes them to a report with a subform pivot graph in my footer/or header. I prefer the header because it looks nicer. My problem is, my subform pivot graph does not update with my GetFilterFromListBox results. I did docmd and then tried run command when the button is selected and the report portion updates to the GetFilterFromListBox, but the subform pivot does not. I think I need to someone link the child and master but do not have a primary key in the GetFilterFromListBox to do that. Do I need to put a hidden one in both? And if I do that how does that hidden, let's say textbox where the primarykey would link know to use a GetFilterFromListBox function? Is there a way to refer to a function a public function that is in the child and master? I have looked online to see if this is possible but not found anything yet.