HOW TO OPEN A FORM BASED ON A SELETION IN A COMBO BOX 2

[HerickP]

hi,<br><br>I have got a form with a combo box with 3 rows in it: Vendor1 vendor2 vendor3, and also a command button named

 

[orionsong]

please be more specific in your question

 

[HerickP]

sorry, I dunno, but what I typed didnt show here....<br><br><br>Ok:<br><br>I have a form with a combo box and a command button labeled &quot;next&quot;; the combo box has three selections: &quot;vendor1&quot; vendor2 and vendor3&quot;; what i wanna do is link each selection to a form ( selection vendor1 to form vendor1); so what I would like to happen is that when I select vendor1 from the combo box, then pressing the command button &quot;next&quot;, it will open form named vendor1, or if I select vendor2 on the combo box, and pressing next will open form vendor2&quot;. Really simple, but I can get to work or code it.... Help me!!! thanks again<br>

 

[Cornerstone]

Just add this code to the button:<br><br>docmd.openform [yourcomboboxname]<br><br>

 

[HerickP]

Didnt work, I dont think its only that code.......

 

[Cornerstone]

Yes, it does work. Are your forms named exactly the same as the way they are spelled in the combo box? Did you spell the name of your combo box correctly after docmd.openform?<br><br>What kind of error did you get?<br><br>I tested it before posting.

 

[HerickP]

THANKS MAN!!!! IT DID WORK!!!!!! THANKS A LOT!! and I will come with more questions, cause I need to get this project done for my boss, and I am a newbie in access.....but thanks anyways!!!!!!