There's no very convenient way to use an option group to represent a
variable list of items, such as a list of Products. The value for each
option button must be either set manually (a true grind and impractical if
the list could EVER change) or in code (requiring some naming rules or very
tidy tag use and still impractical if the list could EVER change).
If you want to see all the products at once, use a ListBox insteadof a
ComboBox. Then you still get your live list of products, but you can select
just like an option group, just by clicking on the desired value. The
ListBox, of course, differs from the ComboBox primarily in the display (list
for listbox versus single textbox for combobox until opened). So, your
listbox can still be bound to the ProductID field and the whole app works
almost identically to the way it did before. In fact, the only likely
change is that you might name the listbox differently form the combobox.
Otherwise, no difference. |