Filling in forms automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a form that has a list box populated with a number of
Parts I would like the form to fill in the price of the part in a text form
field when a certain part number is selected, I only have 5 parts to select
from. I thought I could use an IFTHEN statement but it appears that this is
only able to be used if I had only 2 parts to select from. Any ideas???
 
You can use conditional fields to process any number of different results eg

{IF {Dropdown1} = "Widget" "$10.00"}{IF {Dropdown1} = "Gubbins" "$12.00"}{IF
{Dropdown1} = "Thingummy" "$20.00"} etc
Insert the fields using CTRL+F9 for each field boundary pair and put no
spaces between the fields.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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

Similar Threads

tables / fill in form 1
Fill-In Form Problem 3
Series fill only copying and fill series greyed out 1
Form for Parts-Tools Lists 0
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Populating form fields 4
Access Compare records in same access table 0
New to word, tables and Forms assistance 1

Back
Top