I am trying to get an event to work so that when a user hits a toggle
button, there are 5 toggle buttons in a frame a unique value list is
populated in a combo.box.

However I end up with the text value not the tblvalues in the combo
box. What do I need to do.

Private Sub TogProgramming_GotFocus()
cbxSubCategory.RowSource = "tblprogramming"
End Sub

flebber wrote:


It sounds like the combo box's properties do not reflect
what the row source table/query is returning. Check the
BoundColumn, ColumnCount and ColumnWidths properties against
tblprogramming's field list.

Maybe all you need to do is use a query to select just the
two fields the combo box needs?

--
Marsh

On Jan 9, 3:22*pm, Marshall Barton <marshbar... (AT) wowway (DOT) com> wrote:
What is the "boundcolumn". Where do I find its properties?

flebber wrote:


The BoundColumn property tells the combo box which field in
it's row source should be used as the combo box's value.

The combo box properties are in the combo box's property
sheet. Open the form in design view, then use the View menu
to display the property sheet or double click the combo box.

See VBA Help for details about a specific property. Easiest
way to get to a property's help topic is to click on the
property's name in the property sheet and hit the F1 key.

--
Marsh