MS Access Subform- filtered account detail

MS Access Subform- filtered account detail

Didn't find your answer?

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.

Simon Hurst
By Simon Hurst
13th Feb 2003 08:46

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

Thanks (0)
avatar
By neileg
13th Feb 2003 09:14

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.

Thanks (0)
avatar
By Mick Eaton
13th Feb 2003 15:56

Thanks to Simon Hurst & others re Access forms
Many thanks for the response. I was able to change my approach to the problem and solved it by using an ordinary form with the Heading for the total and the Detail for the related transactions, selecting Tabular instead of Datasheet.

Thanks (0)