dynamictiger
Registered User.
- Local time
- Today, 15:15
- Joined
- Feb 3, 2002
- Messages
- 270
I have two forms set up. The first form is a client job booking form. The second is a kitset job form.
If you choose you can add a kitset job to a client job. When you click add on the kitset button form ADO updates the underlying recordset for the stock tables and updates the field for the labour time. All this is fine.
The following line
Form_frmServJob.JobDescription = Nz(Form_frmServJob.JobDescription) & vbCrLf & Me.KitsetDescription
Appears to work in that it adds the kitset description to the job description field on the form. However, when I close and reopen the job form the job description is not there.
The rest of the form saves fine.
The field job description is a memo field although I cannot see why this would affect the outcome.
If you choose you can add a kitset job to a client job. When you click add on the kitset button form ADO updates the underlying recordset for the stock tables and updates the field for the labour time. All this is fine.
The following line
Form_frmServJob.JobDescription = Nz(Form_frmServJob.JobDescription) & vbCrLf & Me.KitsetDescription
Appears to work in that it adds the kitset description to the job description field on the form. However, when I close and reopen the job form the job description is not there.

The rest of the form saves fine.
The field job description is a memo field although I cannot see why this would affect the outcome.