Access 2k Calculations

[Danny]

Greetings,
I posted this before, and left out some information. I’m using Access 2000 and my questions:

1. I have a main form called Household and a subform called Applicants. In the main form I have a field called NumOfApp. I would like NumOfApp to be automatically filled depending on how many people applied in the Applicants form (subform).

2. In my subform I also have fields like DateReceived, DateDue, and AppStatus (with combo boxes New, Dss, Eapp etc.)
If the user selects New from AppStatus drop down, DateDue is calculated by adding 10 workdays to the DateReceived field. How can I make DateDue to be filled automatically (DateReceived + 9) when New is selected from AppStatus drop down field?

Thank you in advance,
DD

 

[jennyc]

>1. I have a main form called Household and a subform called
>Applicants. In the main form I have a field called NumOfApp. I
>would like NumOfApp to be automatically filled depending on
>how many people applied in the Applicants form (subform).

1. To put a summary in your main form you need to:
a) go to your subform.
b) in design view, extend the footer area
c) add a new control in the footer. The control will be to calculate your number. In the Control Source property this could look like =sum([Cost]) where cost is a field name, and you want a total cost. In your case this would be something like =count([AppID]) this will give you a head count. (where appID is a field in your applicant form - any non blank field will do).
d) name this control eg: CountOfApplicants
e) in your main form create a control where ever you want
f) in the control source property enter: =[Applicants].Form![CountOfApplicants] This is the reference to the calculation above.
If this gives a #name error there could be a syntax error check help for something like "calculating total in subform" as the syntax can be fiddly.


>2. In my subform I also have fields like DateReceived, DateDue,
>and AppStatus (with combo boxes New, Dss, Eapp etc.)
>If the user selects New from AppStatus drop down, DateDue is
>calculated by adding 10 workdays to the DateReceived field.
>How can I make DateDue to be filled automatically
>(DateReceived + 9) when New is selected from AppStatus drop >down field?

Is your subform based on a query? or on a table?


Thank you in advance,
DD