Copy data from field on a form/paste it to a field in another form

[Pierre]

I have a database with a form called "Workorders". We send technicians out to
customers to perform service based on the created workorders. Sometimes the
technician return notes (i.e missing 1 screw, replace at next service) for
the next technician to perform at the next service.
I create a second form called "Notes for next service", then add a button on
the Workorders form to open this form.
The notes are entered to the form called "Notes for next service" by the
administrator when technician return their service reports. The records are
stored by serial number ID.
Whenever a new workorder is created for that serial number the administrator
opens the "Notes for next service" form. Then has to manually copy the notes
and paste them to the new workorder so that they show up on the workorder as
additional work to be performed.

Is there a code I can use to automatically copy the data from the "notes"
field on the "Notes for next service" form and paste it to the "Notes for
next service" field on the "workorder" form?

 

[tina]

since your work order record includes the serial number, and the notes
include the serial number, just include the notes table in the query that
pulls work orders (for printing, exporting, however you get them to the
technicians), linked on the serial number. now, for practical purposes, the
notes are part of the work order. presumably the notes table includes some
kind of date field, so you'll want to pull only the most recent date so the
most recent notes record will be included in the work order.

hth

 

[Pierre]

I think that would work, but how could I ensure that only the most current
notes if any would be printed on the work order?

 

[tina]

well, SQL isn't my strong point, by any means. you might try a query based
on the work orders table and the notes table, linked on the serial number.
make it a Totals query, grouping by the work orders table's primary key
field so you'll get every work order, and maxing the notes table's date
field.

if that doesn't work, suggest you give up on this thread (unless someone
better at SQL steps in to help) and post again in
microsoft.public.access.queries where you're more likely to get expert SQL
help.

hth

 

[Pierre]

Thank you
I will try your suggestion, its at least a start.