One Table Form Problem

[AccessRookie]

Hello,

I have a Table consisting of only 3 Fields: Part Number, Cost Per Hour, Labor Rate(fixed at $45).

I want to build a Tabular Form that uses these fields and 2 or 3 other calculated fields on one row at a time.

I want to have the ability to "drop down" on the Part Number, have it automatically populate the cost per hour field.

Then I want to do the same thing all over again on Row2, Ro3, etc....through Row50 if need be.

How do I do this?? I am at a total loss...

Thank You very much for at least poitning me into the right direction =)

Marianne

 

[RickSpr]

I suspect by a "tabular form" you mean one built by the Form Wizard that displays multiple rows. If that's correct, what you want can't be done.

Calculated fields are associated with unbound text boxes. Unbound text boxes on a form whose current view is Datasheet or Continuous Forms always display the same value for every row--whichever value was last assigned. There's no way to change this.

However, if what you actually want to do is calculate a value and store it in a field in the table, you just need to bind the calculated control to the table field (set the Control Source property). Then, in the AfterUpdate event of the drop-down box, write code that calculates the value and assigns it to the text box.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[AccessRookie]

Hmm, okay, I am not sure how to make what I am after then.

I was hoping to have a FORM in which I select the Part Number from a Drop Down box, then the cost automaticaly pops in for the second field, and the 3rd field is the foxed labor rate field, Field 4 and 5 would be calculated.

All of that is on Row 1 of the FORM.

Repeat for row 2, 3, 4, etc...

I am trying to use this as an "estimation" tool for budgeting and I would like to have all the part numbers and cost stored so that I could select the 30+ Parts to add to a Truck and then get a Line Total and Grand Total of all the Work needing to go onto a Truck. But I don't need the information saved in a Table, I just want it calculated so I can Print it and then do it all over again for the next truck.

Any suggestions would be GREATLY appreciated!
Thank You!

 

[RickSpr]

I may not have been as clear as I should have been. Whether or not the form was built by the Form Wizard, if it has unbound controls and is displayed in either Continuous Forms view or Datasheet view, a given unbound control will display the same value on every row. You can not change this.

Access, after all, is a database application. What you want to do is number crunching. Perhaps you should consider implementing this in Excel instead. I don't have any experience with using Excel to retrieve data from an Access database, but I'm sure it can be done.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein