combo box / text box

[Guest]

I have created a form [frm_master_list] on that form i have a combo box that
has a list of items. I would like to show a option gruop based on a selection
from the combo box IE.... If i pick Dining room from the combo box i would
like the option group box to appear and show the options 1) 8'-0" ceiling 2)
9'-0" ceiling <145 sq ft 3) 9'-0" ceiling >145 sq ft. Each one of the option
groups have a model number asscotated with it. I would like to be able to
select and option group button and it put the model number in the model
number textbox on the form. I hope this makes sence. Any help would be great
thanks. Erik

 

[Jeff Boyce]

Erik

Creating and showing/hiding different option groups for each selection from
a combo box will get messy.

Since you already understand how to do a combo box selection, why not use
"cascading combo boxes" and have a second combo box list choices based on
the selection in the first combo box?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Can you explain how to create cascading combo boxes? It sounds like it will
work too. Thanks for any help.

Erik

Creating and showing/hiding different option groups for each selection from
a combo box will get messy.

Since you already understand how to do a combo box selection, why not use
"cascading combo boxes" and have a second combo box list choices based on
the selection in the first combo box?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have created a form [frm_master_list] on that form i have a combo box
that
has a list of items. I would like to show a option gruop based on a
selection
from the combo box IE.... If i pick Dining room from the combo box i would
like the option group box to appear and show the options 1) 8'-0" ceiling
2)
9'-0" ceiling <145 sq ft 3) 9'-0" ceiling >145 sq ft. Each one of the
option
groups have a model number asscotated with it. I would like to be able to
select and option group button and it put the model number in the model
number textbox on the form. I hope this makes sence. Any help would be
great
thanks. Erik

 

[Linq Adams via AccessMonster.com]

You can use this phrase to google and you should get a bunch of hits. Here's
a tutorial on the subject from TheScripts:

http://www.thescripts.com/forum/thread605958.html

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

when i have that working, can I have the item that i select from the second
combo box show in the text boxes on the form? Example: If combo box2 shows 2
columns of data and I have 2 text boxes that are on the form with the same
information i would like the items to be pasted into the text boxes from the
combo box. I hope this makes sense. Please let me know if you can help or if
i need to be more clear. Thanks so much!!!

Erik

Creating and showing/hiding different option groups for each selection from
a combo box will get messy.

Since you already understand how to do a combo box selection, why not use
"cascading combo boxes" and have a second combo box list choices based on
the selection in the first combo box?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have created a form [frm_master_list] on that form i have a combo box
that
has a list of items. I would like to show a option gruop based on a
selection
from the combo box IE.... If i pick Dining room from the combo box i would
like the option group box to appear and show the options 1) 8'-0" ceiling
2)
9'-0" ceiling <145 sq ft 3) 9'-0" ceiling >145 sq ft. Each one of the
option
groups have a model number asscotated with it. I would like to be able to
select and option group button and it put the model number in the model
number textbox on the form. I hope this makes sence. Any help would be
great
thanks. Erik

 

[Jeff Boyce]

Erik

In the combo box's AfterUpdate event, you can use something like:

Me!txtYourRelatedTextbox = Me!cboYourComboBox.Column(1)

to "put" the value in the combobox's 2nd column (that .Column() command uses
zero-based counting - 0, 1, 2...) into the related textbox. Of course,
you'll need to use your controls' names.

Note, since the data that's going to the textbox is already in your database
(it came in the combobox query), you probably will not need to store it
again. That textbox can be unbound.

Regards

Jeff Boyce
Microsoft Office/Access MVP

when i have that working, can I have the item that i select from the
second
combo box show in the text boxes on the form? Example: If combo box2 shows
2
columns of data and I have 2 text boxes that are on the form with the same
information i would like the items to be pasted into the text boxes from
the
combo box. I hope this makes sense. Please let me know if you can help or
if
i need to be more clear. Thanks so much!!!

Erik

Creating and showing/hiding different option groups for each selection
from
a combo box will get messy.

Since you already understand how to do a combo box selection, why not use
"cascading combo boxes" and have a second combo box list choices based on
the selection in the first combo box?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have created a form [frm_master_list] on that form i have a combo box
that
has a list of items. I would like to show a option gruop based on a
selection
from the combo box IE.... If i pick Dining room from the combo box i
would
like the option group box to appear and show the options 1) 8'-0"
ceiling
2)
9'-0" ceiling <145 sq ft 3) 9'-0" ceiling >145 sq ft. Each one of the
option
groups have a model number asscotated with it. I would like to be able
to
select and option group button and it put the model number in the model
number textbox on the form. I hope this makes sence. Any help would be
great
thanks. Erik