View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mas mas is offline
external usenet poster
 
Posts: 5
Default help creating dynamic forms

Hello All,

I need help creating a form. I have a list of names that I get from a access
query. The list is not alway going to be the same length or have the same
data. I want to associate a number (1 - 7) with each of the names. How can I
do that dynamically with a form?

Here's what I am looking for:

Name 1 pull down menu with the number 1-7
Name 2 pull down menu with the number 1-7
..
..
..
Name n pull down menu with the number 1-7

I know how to use a ComboBox on forms, but how do I make it dynamic and
place additional ComboBox's dependant upon the number of Name's.

Thanks,