My form includes calculated fields - Time, Labor, Part Cost & Total Costs. At the moment time is entered as say 1 or 2 or 2.5. Then Labor is calculated as [Time]*65 ($65.00 being the current hourly charge out rate). Then Part Cost is entered. Then Total Costs is [Labor]+[Parts_Cost]. I have put these calculations in the query not the form.
My problem: When the user increases his hourly rate --- how can I refer the control to another form ie. say frmAdmin which has a field [Rate] and then have that reflected in data from that date only. I have tried a thousand different ways including changing the formula in the query but that, of course, changes ALL the records.
This is probably so simple but I just can't figure it!!
TIA
My problem: When the user increases his hourly rate --- how can I refer the control to another form ie. say frmAdmin which has a field [Rate] and then have that reflected in data from that date only. I have tried a thousand different ways including changing the formula in the query but that, of course, changes ALL the records.
This is probably so simple but I just can't figure it!!
TIA