Form & Subform VB help

K

kimberlyb

I need to help to create a form and subform that will allow users to enter
data by quarter.

Form 1: The main form will allow the user to update maintenance information
about a particular project, e.g. start date, end date, status information,
etc.

Subform: The subform will need to be in a tabular style where there is list
of projects and columns for data entry for revenue by month. The main
revenue table has a combo box to select the month end date, then fields to
collect total units sold and average selling price. I need the subform to
look like . . .

Project Month1Units Month1ASP Month2Units Month2ASP etc . . .
Project1 1000 2.50 1000 2.49
Project2 2000 1.50 2000 1.51

I will need to calculate the total revenue by month Month1Rev = Month1Units
* Month1ASP, then by total quarter Q1Rev = Month1Rev + Month2Rev + Month3Rev


Note: When you click on the project to enter the monthly data, the
maintenance information on the main form should update to the correct project
maintenance information. I was told this could be done through code however
this is beyond my ability.

Any help is greatly appreciated . .
 
U

UpRider

Kimberly, your design (or description of it) makes no sense.
The main form allows you to input data about a "particular project". To
Access, this means that the subform can contain data about *that project
only*. Yet, your subform shows Project1, Project2, etc.
Can you elaborate for us?

UpRider
 
K

kimberlyb

I'm sorry. I see the formatting in the original post didn't work.

I have a revenue table that has Project, date, units, & asp fields. I need
to create a form for data entry that captures the data in a columnar way for
each month like a cross tab that can be grouped by quarter. Is there a way
to create this? The second portion is that the user will also need to update
certain fields in a maint. table but to keep the user from having to go to
another form, I would like to have this info available also to update. Any
thoughts?

thanks,

Kimberly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top