Extract the values from the fields in one form to insert them into the next form

[Ranger351w]

Hi guys,
I have a db where the main table/form is OperatorReports. I have sub-forms that allow users to review the reports by WorkOrderNumber/Date. The challenge I now face is allowing the user to open a new Operator Report that has the header fields autopopulated by the information on the report they were looking at so that they can continue the project but add their own information. I tried to run with an unbound form that reproduces the original OpReport form but uses expressions to fill the fields and an append query to add the data to the table. However, I get validation errors running the apQuery.
My goal is to come up with some code to create a dataset of the header info to put into the original OpReport form.
Not sure of the best way to accomplish this task and am open to any suggestions.
Respects and regards,
Chris

[June7]

So you are moving to a new record on the main form? One method is to set the DefaultValue property of each of the controls you want to carry value forward. Review http://allenbrowne.com/ser-24.html

[Ranger351w]

I don't want the values to be default... Just a one time transfer to a new record because the worker is, in this instance, continuing a project but needs his own Op Report, though the header information is the same. I'm not saying this is a one time event. But that on occasion, the worker will be continuing a project and the header data will be the same. The goal is to allow operators to review the previous op report and then click a button to open a new op report that has the header data from the previous worker's report, because he is continuing that persons project.
The procedure is to open the "Sub Form Reports" from the switchboard, and select a work order number, then open the "By Work Order" read-only form. From there select "Continuing Work Order" to open a new record with header info already populated except "Date", "Shift" and "Operator".
Respects,
Chris

[June7]

Programatically setting the DefaultValue property will be in effect only until the form is closed. User can still type other values in the new record.

An alternative is to set public/globally declared variables (variables declared in the form or general module header). This allows the variables to be referenced by any procedure in that module or in the case of variables declared in general module, anywhere in the db.

[Ranger351w]

I checked the link and from the description Mr. Browne gives it looks like it might be just the thing. It may take some additional work to have the Op Report review be in the actual Op Report form in a read only mode and then have that come off as the new record is brought up...

[Ranger351w]

Whew! I was able to correct the issue by building my original ApQuery from scratch... Not sure what the difference was, but it works now... The only issue I have remaining is some calculations... Is there an expression or operator that will prevent the calculation from executing if the field value is zero?

[June7]

Maybe use IIf

IIf([field]=0, Null, do calc)