please help! copy field values from two forms

pattyt

Registered User.
Local time
Today, 10:23
Joined
Aug 10, 2001
Messages
13
I have two forms, one is main callsMFrm the 2nd form is callsTFrm. I open the main form and enter alot of info (place, tags, serials, fixedate, fixtime,solution ect) then click a button to open the callsTFrm form which pops up with the same HELPNO as my main form. Both forms show on the screen. I enter my new info(trlfixdate, trlfixtime,trlsolution ect). I want to click on the callsTFrm a button that saves my orig values in my first form to a memo field and replaces those fields with my trail fields and closes the trails form.In other words two techs could go out on the one call but not all calls will be reassigned.The main form will have alot more info than the 2nd form.I've seen some of your examples..still stuck.The helpno must match before any changes gets done.Need code not action queries. Got an error on my execute code.Thanks!
 
Private Sub YourButton_Click()
Dim sMEMO as String

'Create the data to be appended to the memo field.
sMEMO=Forms.callsMFrm!fixedate & " " & Forms.callsMFrm!fixtime & ": " & Forms.callsMFrm!solution

'Append data to end of memo field
Forms.callsMFrm![MEMO FIELD]=Forms.callsMFrm![MEMO FIELD] & vbcrlf & sMEMO

'Replace Data
Forms.callsMFrm!fixedate=Forms.callsTFrm!trlfixedate
Forms.callsMFrm!fixtime=Forms.callsTFrm!trlfixtime
Forms.callsMFrm!solution=Forms.callsTFrm!trlsolution


End Sub
 

Users who are viewing this thread

Back
Top Bottom