Hello Experts! I am stuck and need your help. I have a 2 part request:
First, using Access 2013, I am trying to create a title in a form based on the user's entry in a parameter query on the date. I have done this before with a report where in the query, I used:
Criteria: Between [Enter Start Year] And [Enter End Year]
Then I created a title for the Report by using a textbox with the formula:
="Total Sales from " & [Enter Start Year] & " and " & [Enter End Year] & ""
However, in Form View, this title formula creates a #Name? error. Is it possible to pass content from a parameter query to a textbox in Form View? I know the obvious answer is to print it to a report, but the client wants to filter the data in Form View with data entry capabilities and see the title change to match the years they select. (Note - the parameter query is sorting SubForm1 datasheet.)
Second, I would like the controls that contain sales totals to appear or disappear based on the user's entry in a parameter query on the date (i.e., if the user enters "2010" Start Year and "2012" End Year, the fields containing totals from other years are hidden (Visible = False)) (Note - the sales totals are individual controls for each year in the main form.)
I'm thinking of creating a command button in Form View that when clicked, it will filter years selected in the datasheet and hide totals from other years, but I'm not sure if that is the best approach.