Form Macro?

[Mike Hughes]

Access 2003
I have Form to summarize information from several other forms into one form using sub forms. Each of the forms is connected to each other by a case number.

One of the sub form summarizes information from a table which tracks total $ received by case. That table has all the receipts which make up the summarized information on that sub form.

I have a command button which I want to link to the case number which is currently displaying all the case information (the form and all the sub forms).

I can make the command button open the table where all the receipts have been stored but I don’t know how to limit what is returned to the case number which is currently being displayed on the form(and sub forms)

If you can understand what I’m saying, does anyone know how I could do this?

 

[Steve R.]

My guess is that you will need to use one or more Domain Aggregate methods. The one in question probably being DSum. Look-up Dsum in Access help.

 

[dcb]

I have a command button which I want to link to the case number which is currently displaying all the case information (the form and all the sub forms).

I can make the command button open the table where all the receipts have been stored but I don’t know how to limit what is returned to the case number which is currently being displayed on the form(and sub forms)

If you can understand what I’m saying, does anyone know how I could do this?

Open the Table - No
Open a query rather
Create a parameter query that gets its value from your form
http://www.btabdevelopment.com/main...renceinaqueryscriteria/tabid/115/Default.aspx