Multiplying Values from a form and table

[Lxmanager]

Hi, I have what is probably a simple problem.



I have a form called frmInspSht linked to a table called tblInspSht. On the form I have two text boxes one called ReworkHrs and one called ReworkCost.

I also have another table called tblFactoryDetails and within that table I have a field called HourRate with a value in it of 40.

The operator fills in the form and enters a figure in the ReworkHrs text box, for example 5.

What I need then is the database to multiply the ReworkHrs text box by the HourRate value in the tblFactoryDetails table and display the result in the ReworkCost text box on the form, at the same time populating its field in the tblInspSht.

so when they enter 5 in the ReworkHrs text box the ReworkCost text box will show a value of 200 and both will be stored in the tbl.

I know this is probably simple but I cannot figure it out. Please could someone help and show me how.

Many Thanks, Andy

[RuralGuy]

How do you know what records to look at in the tblFactoryDetails table?

[Lxmanager]

Hi, I only have one record in the FactoryDetails table, that just holds things like factory name, address and variables like the one I am using. The value 40 is the man hours of the factory. The idea is if that changes I only have to change that table instead of trying to find where it is in the database.

[RuralGuy]

So the AfterUpdate event of the ReworkHrs TextBox will have something like this in it:
Me.ReworkCost = Me.ReworkHrs * DLookup("[HourRate]","tblFactoryDetails")

[Lxmanager]

Hi, it took a bit of jugling around but it is now working fine, thanks very much for your help.

[RuralGuy]

Great! Are you ready to use the Thread Tools and mark this thread as Solved?