Recent content by jbutcher

Yes, thank you! The date variable had to be formatted properly. It works now! Cheers!

Hi there, I am having a heck of a time attempting to open a form and filter it automatically based on a date derived from a control on another form. I am using the DoCmd.OpenForm method and applying and applying criteria to the "WhereCondition". Initially the code looked like this and worked...

I have two tables with a one-to-many relationship, we'll call them Table1(one) and Table2(many). Table1 contains a field that is to hold the average value of a field in Table2 (call it "Value") based on a common ID (the one-to-many relationship). So: Table1 "ID" "Avg" 1 SomeAverage1...