Data Validation

B

broknlgs24

i'm pretty new when it comes to creating Outlook Forms and have a few
questions. i'm trying to create a form in outlook in which an end user

would fill out and email to someone else for data entry. the form has
6 columns and 8 rows. of the 6 columns, 4 are text boxes and 2 are
combo boxes. here's a layout of the columns (row 1 only) -

name action ID ID2 name2 serial#


name = text box. required.
[TechName1] <> ""


action = combo box. contains 4 values. must equal one of the 4 values.

[AMD1] = "Add" or [AMD1] = "Delete" or [AMD1] = "Modify" or [AMD1] =
"HHT"


ID = text box. must equal 7 characters.
Len( VZID1 ) = 7


ID2 = text box. must equal 3 characters.
Len( VZID1 ) = 3


name2 = combo box. contains 6 values. must equal one of the 6 values.
[AM1] = "xx" or [AM1] = "xx" or [AM1] = "xx" or [AM1] = "xx" or [AM1] =

"xx" or[AM1] = "xx"


serial# = text box. required
[OS1] <> ""


rows 2-8 are optional; however, if an end user decides to edit any of
the remaining rows, all remaining columns in that row must have the
same data validation as row 1.


does any of this make sense? could i use a checkbox to set row-by-row
visible if checked?
 

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


Top