I am attempting to create an Access Form with Subform to filter accounting data based on date. The form shows the date and total for that date. The subform shows the detailed transactions for that date. The links do not work so the date parameter has to be enterd first for the Form and then for the Subform even though both come from the same query. Any suggestions as to the source of the problem or an alternative approach, please?
Michael Eaton
Replies (3)
Please login or register to join the discussion.
Access form and subform
I'm not sure I fully understand what you are doing, but could you achieve what you want with a form that lists all the transactions, and includes a 'combo' box in the form header where you can choose the date you require, and then apply a filter to the form to just display transactions for that date?
Depending on the version of Access, the combo box wizard should include an option to:
'Find a record on my form based on the value that I selected in my combo box'
Sorry if I have misunderstood the problem.
Simon Hurst
Not clear how you are constructing this
It is unusual to have a form and a subform based on the same query. I think the query is running twice which is why you are being prompted for the date twice.
I suggest you create an unbound form that prompts your user to enter the relevant date. Drop this date into your query as the criterion using the syntax = Forms!MyPopUpForm![MyDate]
Use a single continuous form for your display, based on your query. You can include the date value in your form header using the same form of referencing. Include the total that you look for in the report footer. If you must have this in the top of your form, you may have to use a DSum calculation.