Converting an Event from Formflow to Word

P

Poli

I have a program called Form Flow and after Windows XP it will be obsolete
and i am trying to convert my forms to word. I have an event that I need to
convernt to VB using VB language. My Event is a look up process that when it
looks at a field will add a certain content to another field based on what it
sees. I need help. Also will this event work in Word on a drop-down Form
Field?

My Event:
Sub LookupPenDwellTime
if Application.ActiveForm.Fields("PROCD").contents = "SP2G-00-017 REV. B" then
Application.ActiveForm.Fields("PenDwelTime").contents = "min. of 15
mins. and max. of 20 mins."
elseif Application.ActiveForm.Fields("PROCD").contents = "SP2G-00-015 REV.
C" then
Application.ActiveForm.Fields("PenDwelTime").contents = "min. of 25
mins. and max. of 30 mins."
end if
End Sub
 
J

Jean-Guy Marcil

Poli said:
I have a program called Form Flow and after Windows XP it will be obsolete
and i am trying to convert my forms to word. I have an event that I need to
convernt to VB using VB language. My Event is a look up process that when it
looks at a field will add a certain content to another field based on what it
sees. I need help. Also will this event work in Word on a drop-down Form
Field?

My Event:
Sub LookupPenDwellTime
if Application.ActiveForm.Fields("PROCD").contents = "SP2G-00-017 REV. B" then
Application.ActiveForm.Fields("PenDwelTime").contents = "min. of 15
mins. and max. of 20 mins."
elseif Application.ActiveForm.Fields("PROCD").contents = "SP2G-00-015 REV.
C" then
Application.ActiveForm.Fields("PenDwelTime").contents = "min. of 25
mins. and max. of 30 mins."
end if
End Sub

See this site for a complete tutorial on creating forms with Word:
http://www.mousetrax.com/techpage.html#autoforms
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top