Append query append date to separate field?same table

[valmatic]

Hi. I am putting the finishing touches on a maintenance and equipment database.

Maint. staff schedules a maintenance job. Once that job completes and is an on-going job (based on frequency), my append query runs and auto-schedules the next instance of this job. The append query pulls most of the data from field to like field in the next record of my table but the request date is coming from a separate, calculated date in another field. (most fields are A to A, B to B, C to C, and my date field is Z to D - all in same table) Anyway, the date field keeps coming up blank in the new record.

I do have two separate forms running almost the same query and it works fine every time on the other form. (basically one is an initial maint. form and the other is my edit maint. form, where the date does not transfer.

Hope this makes sense - Any help would be huge. Btw, I did make sure the format and input mask of both fields are the same.

 

[valmatic]

Maybe a better description of issue:

Hi.
I have a ScheduleMaintenance Form and an EditMaintenance Form with a clicky button on both forms that runs a bunch of code, one of which runs an append query that auto-schedules the next instance of an on-going maintenance job once an instance is marked complete. All data transfers to the new record fine on the ScheduleMaintenance form but the new request date will not transfer when the EditMaintenance form is used. I get no errors and the append runs fine otherwise but that date won't populate on the one form.

Way it works - RequestDate field and NextDate field. Once a job is marked complete, the NextDate field calculates and fills, based on the input from a couple of other fields and the RequestDate field. My append query runs and populates the next record. The RequestDate on the new record should be populated by the previous records NextDate data.

As I said - all else works, including my auto-number and all works on my other form (almost identical query) but not on this form.

I did make sure the format and input mask of both fields are the same and I've re-created my append query for that form a number of times with no luck.

Hope this makes sense - Thsi is driving me nuts so any help would be huge.
thanks

 

[valmatic]

I figured it out. Forgot I posted another issue about this same query some time ago but I only needed to refresh the data prior to running the append. The table wasn't getting populated with the calculated date so had nothing to transfer over...

I love it when a plan comes together...