Update field in Form yet save as new record

[cjb135]

Hello All -

I'm working on a "simple" dbase that will track the invoice payment process.

Does anyone know how to:

Create a form that will generate a NEW record when 1 or more of the fields for the original record is updated?

Example: Search Form for Invoice X, update Status field & Update date field, SAVE as new record.

Hope to build multiple Status records for 1 invoice that will allow work flow time analysis between process, i.e. Status steps.

Any and all help is VERY welcome.

thanks,
cjb135

 

[Bryan]

I don't think I'd try to create a new record simply by updating a field in a record returned by a search. Even if you could do it, it seems like a dangerous way to proceed.

One possibility would be for the form that contains the search result to have it's fields locked so that edits could not be done on that form, allowing the user to review the data. That form would have a command button that allows the user to edit the record. The code for that button would spawn a new form (your new record), bring the data forward from the search result form and then hide/close the search result form. (The original form might need to remain open until the new form is closed.)

I've never done this, but it seems like a workable possibility, at least in my head.

 

[rodmc]

you could have the form open up to a new record and have a control that copies the data from the previous record into your new record, then you can make the changes you need and then save