Date Calculation When Switch From Form View to Datasheet View; Take Two

[HMEpartsmanager]

Have a quick update on where I am on this. I have the state fair and the Heart concert to go to in a little bit, but wanted to keep abreast of where I left off the other day.

Reviewing everything, it turns out that I whought you had to call the control by it's source name, but as I looked, this particular source name was one of the few where I didn't have the NAME being equal to it's CONTROL SOURCE.

By changing the naming convention from CONTROL SOURCE, to it's NAME; I got somewhere.

' This Almost Works; But I Get A Date Of 12/30/1899


' Me.Purchase_Orders___Sub.Form.ordlineEta.DefaultVa lue = Me.ordEta
' This produces the same result
' Me.Purchase_Orders___Sub.Form.ordlineEta.DefaultVa lue = #06/22/2006#
' This produces the same result
' Me.Purchase_Orders___Sub.Form.ordlineEta.DefaultVa lue = '06/22/2006'

So I can get the ordlineEta to change show 12/30/1899 when the code above is in place. When I take it out, the field acts like it always has. So it looks like I am closer to determining how to fix this issue. I think my next step is to look for a different place to put the above line of code. Maybe instead of the Main Form's Current Event, maybe there is a better location to put this code.

Things I do know is that the ordlineEta works for everything but when going from Datasheet to Form View. My subform blank lines where this default data is placed, does not get saved until I enter the whole line of data and save the record. The above line of code from June looks like it wants to work, but has a slight issue. Not only does it have a default of 12/30/1899, it does it for every record. I need to find a way to get that 12/30/1899 to be the Main Form's ETA Field, or determine if there is a way to get my ordlineETA to grab the current record number's ordEta.

I am working on it, and I can continue tomorrow when I return.

Thanks to all who are helping me fix this annoyance.

Tim

[HMEpartsmanager]

Seems that once I figured out that the 'name' is different than the 'control', I was able to solve this by....

PMS Purchase Orders - Main Form (On Current Event)
--------------------------------------------------
[Purchase Orders - Sub].Requery


Now when the current event triggers, it will properly requery the subform which will then grab the correct ETA Date.

Thank you all who have contributed to help me run through this issue.

Tim