combobox list from table result of another combobox

[hunterjj]

I have a table of golf courses. Each table entry contains room for up to 3 tee boxes(ie. Blue, White, Red). I use a combobox to select a golf course. In the next combobox, I want to be able to select which one of the three tees boxes will be used.

 

[dpimental]

In the Row Source Type select value list.

Then in the row source type :
Red;White;Blue

David David Pimental
(US, Oh)
dpimental@checkfree.com

 

[hunterjj]

Red, White, & Blue are examples. They could be any colors. Only the fields in the specific table entry know what the colors are. I need to extract the colors from the table fields and display them in a combo box for single selection.

 

[dpimental]

Then you probably want to do 2 combo boxes.

The first one's Row Source should be the list of Golf Courses.

The second one's Row Source will be colors field and the list of Golf Courses
(make sure to uncheck the "show" checkbox so it doesn't show this information)

Set the Golf Course Criteria to the Combo Box control (This is the first combobox), like this.
Forms![MyFormName]![ComboBox1]

Then Make the First ComboBox AfterUpdate to Requery the 2nd ComboBox

ComboBox2.Requery

Try that and let me know if that works.

David David Pimental
(US, Oh)
dpimental@checkfree.com