Use cmd button to fill textbox

[shariq1989]

I have a form "Maintenance Completed", where there is a text box to enter the engine hours when the maintenance was completed. The users select an engine, a component, enter engine hours and a date.The users are entering the hours in manually but I am trying to write a code for an "estimate" button. The button would "grab" the engine hours from TblHourEntry based on the EngineID selected in the form. Then it would use the date entered into the form in the following equation:

((Date/30)*AvgMonthlyHours (from a query based on engineID)) + MaxofEngineHours(from TblHourEntry based on engineID)

The user can then, either choose to go with the estimated value or go get actual readings and compare them to the estimated to verify accuracy of the estimate.

[jzwp11]

What you describe can be done. You would assign the result of the calculation to the control. The domain aggregate functions will be needed (DAvg() & DMax I assume)

me.controlname=(Date()/30)*DAvg("hoursfield","queryname","EngineID=" & me.engineIDcontrolname) + DMax("hourfield","tblHourEntry","EngineID=" & me.engineIDcontrolname

The me. notation is just a shorthand for the current form. The above assumes that the EngineID field in the query/table is a numeric data type field. If the query already calculates the avg. monthly hours, then I would substitute the DLookup() function in place of the DAvg() function. I'm not sure what you hope to get out of the Date/30 part of the expression.

Without more info on how the tables & queries you mention are structured, the above expression is just a guide. Hopefully it helps