Using many subforms -- must be a simplier way

[Orson9750]

I am using Access 2003. My database tracks how many energy discount applications are sent out to clients. Our clients are low income frail seniors and disabled adults. My staff either mailes the applications to clients or in some cases staff will make a home visit to assist the client in completing the applications.

Each client can qualify for up to six applications. Right now I have 6 command buttons, one to represent each application. Example App 1, App 2, App 3, App 4, App 5, App 6.

Each command button opens a subform with the same information .... a date field and a drop down field with this list--App-Mailed, App-Home Visit, App-Remailed, App-Processed.

I know there must be a better way to record this information then opening six command buttons and recording the same information six times.
I need to be able to report quarterly on what applications were given out to the community and how many of each.

I hope I am explaining this. Your help is appreciated.

 

[RORS002]

Have you tried using one form with drop down menu's? This way you can have all the same fields in one form with one drop down menu indicating the type of application?

 

[GaryPanic]

logic think here (so I might be wrong)
Have the information entered once lets say on the main form and if you must copy the data over onto a sub form have it append this when you click the other buttons - however your d/b - doesn't sound quite right -

data should only be entered once and not multiple times ( thats the general rule)

 

[GaryPanic]

or even

enter data on one form then have 6 tick box's for the corresponding reports..

 

[Orson9750]

Thanks all for your suggestions. I will try both methods.

Gary, I agree with you when you say the db doesn't sound quite right. I am fortunate enough to have a consultant in the office who is working on creating a db for another program. I have talked to her and she will be willing to work with me.