Form auto fill based on a different field value.

macropod · #1 09-18-2014, 05:43 AM

You could change the:
{=RPM+10}
and:
{=RPM-10}
field codes to:
{=(RPM>0)*(RPM-10) \# 0}
and:

{=(RPM>0)*(RPM+10) \# 0}
respectively. This will cause them to display 0s while ever the RPM field is empty. To suppress even the 0s, change the final 0 in each field to:
"0;;"

regwitt · #2 09-18-2014, 06:26 AM

Quote:

Originally Posted by macropod

You could change the:
{=RPM+10}
and:
{=RPM-10}
field codes to:
{=(RPM>0)*(RPM-10) \# 0}
and:
{=(RPM>0)*(RPM+10) \# 0}
respectively. This will cause them to display 0s while ever the RPM field is empty. To suppress even the 0s, change the final 0 in each field to:
"0;;"

That worked beautifully! Is there a book that you might recommend that I might use as a reference so I don't have to bug you guys all the time? My next project is to have a link within the document the user will click on that will search our database for a specific .map file, then search that file for specific parameters. I really like to read books that i can reference in the future.

Again, Thanks a million!!!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MACRO - Insert row based on Form Field Criteria	Elan05	Word VBA	5	04-16-2013 06:39 AM
Nested if field that contains a fill-in field is not prompting for fill-in info	Nccadm	Mail Merge	2	04-02-2013 03:15 AM
Form file timesheet, auto fill date from calander	jkeeney	Word	1	03-21-2012 12:21 AM
Macro to populate a text form field based on dropdown selection	koloa	Word	0	10-20-2011 11:52 AM
How can I fill in form I received in email that used underlines instead of text field	Gail L.	Word	2	05-17-2009 12:38 PM