Open form from combo box

[RuralGuy]

You could also change the Bound column of the cbo.

[aceoftrades]

Now I'm really pulling my hair out...Here is my Table structure:

FormID FormName Forms
1 frm1 Form 1
2 frm2 Form 2
3 frm3 Form 3

If I click on Form 1 in the combo box I want it to open frm1
When I have .Column(0) I get "The form name "1" is misspelled or refers to a form that doesn't exist."
When I have .Column(1) I get "The form name "Form 1" is misspelled or refers to a form that doesn't exist."
When I have .Column(2) I get "The action or method requires a Form Name argument."

[RuralGuy]

.Column(1) should give you "frm1", not "Form 1"

[aceoftrades]

It doesn't...I've tried moving the columns also...it only ever recognizes FormID and Forms columns and never FormName no matter what I change...

[RuralGuy]

What do you have as a ColumnCount?

[aceoftrades]

I'm not sure if it matters but the combo box is Unbound. If it should be Bound how do I change it?

[aceoftrades]

ColumnCount???

[aceoftrades]

Sorry...ColumnCount was 2...I'm changing to 3 and trying.

[RuralGuy]

And I would expect such a cbo *not* to have a ControlSource. (unbound) It can still have a "Bound" column.

[aceoftrades]

Nope...changed ColumnCount to 3 and 4 ... still same. Is there a way to refer to the column field name?

[RuralGuy]

Something else is wrong. Can you zip up and post your db for review?

[aceoftrades]

Ok...here's the file. If you open ToiletF under Product Forms in the top right is the Switch Category Combo Box. Category is the table which propagates the Combo Box. (Form1, frm1, Form 1 was to try and keep things simple)... If you could also look at Switchboard-Add Product-when I open Toilet (or anything else) I want the form to open with the results filtered to only Toilets Catagory... Thank you for your help.

[RuralGuy]

The RowSource of your ComboBox did not contain the field you needed. I changed it for you.

[RuralGuy]

...when I open Toilet (or anything else) I want the form to open with the results filtered to only Toilets Catagory... Thank you for your help.

Convert the Macro's to code for that form (NewProductF) and then complete the WhereCondition argument of the OpenForm command.

[aceoftrades]

Works great...Thank you for your help...