Need help on this 1

[JrClown]

Hello all...
I have a workbook containing a few in-house forms. One of the forms (form 1) contains a drop-down box with options:
1,2,3,4,5,6,7,8
The scenario is that whatever the users inputs in form 1 carries into 2 other forms. I have been asked to create a brand new form to add to this workbook, but to only populate this new form with data if from the form 1 drop-down box options 3,4,7 & 8 are selected.

Hope this is clear... Thanks "The reward of one duty done is the power to fulfill another"
<%
Jr Clown
%>

 

[daimaou]

I'm not sure I understood your problem...

For what I understood something like this should work...

if form1.dropdownbox.Text=3 OR form1.dropdownbox.Text=4 OR form1.dropdownbox.Text=7 OR form1.dropdownbox.Text=8 then
form2.show
'populate what you want on form2

else
'do anything else...
End if

Let me know if this was what you were after

 

[JrClown]

Precisely my friend. &quot;The reward of one duty done is the power to fulfill another&quot;
<%
Jr Clown
%>