Calculating from one form to another

[Nickaroo]

I have two tables, one the “master name” table and two the overtime table….One to many relationship based on employee num. I am trying to create a data entry form that calculates a dollar amount based on a rate that resides in the master name table and a number field that resides on the data entry from. The “total rate” field is on the same form and is where I want to store this information.

Master.Rate x overtime.number = overtime.total

I do not know how to accomplish this task.

Help

 

[jfgambit]

Assuming you have a field on your form for Employee Number use the following
Dim rsRate as Variant

rsRate = Dlookup ("[Rate]","Master Name","[Employee Number] = '" & me.Employee_Number & "'&quot

Me.overtimeTotal = rsRate * me.overtimenumber

HTH



"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[Nickaroo]

That worked...Thanks