Transfering enteries in the same form

scandalous · February 16th, 2007, 11:34 AM

I have a form with the Textboxes InstalTime(Locked) and Labortime.

InstalTime - suggested amount of time it takes to install a part
LaborTime - The Time Used to install a PArt

I need to have the default Value for LaborTime be the # that is populated in InstalTime and still be able to modify it?

I tried

Code:

InstalTime_AfterUpdate ()

if isnull(me.EstLabor) then exit sub   
me.Labor = me.EstLabor

But that didnt seems to work.

mmcdonal · February 16th, 2007, 04:17 PM

I am assuming that this code is on the AfterUpdate event of InstalTime:

InstalTime_AfterUpdate ()

If IsNull(Me.LaborTime) Or Me.LaborTime = "" Then
Me.LaborTime = Me.InstalTime
End If

Where did Labor and EstLabor come from?

mmcdonal

scandalous · February 19th, 2007, 10:15 AM

Hah thats funny I wonder what I was thinking when I posted that. I must of had a case of the Fridays.

I have been trying to use the

InstalTime_AfterUpdate ()

If IsNull(Me.LaborTime) Or Me.LaborTime = "" Then
Me.LaborTime = Me.InstalTime
End If

Which you suggested but it still isnt working.

I am starting to think that because the instalTime is populating when I open the form I need to place it someplace else?

scandalous · February 22nd, 2007, 11:15 AM

Wow I tried it again and it worked! thanks!