order of Step through option group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I got around adding a button in an option group (asked below) by putting in
30 options hidden and then they are made visible and captions added with the
following code.
For Each ctl In Me!Choice.Controls
If Not category.EOF Then
ctl.Visible = 1
Debug.Print category!CompanyName 'make sure of the
ctl.Caption = category!CompanyName
category.MoveNext
End If
Next ctl
My question is that to get 30 choices I used two columns and even though the
option values are numbered top to bottom the options are populated left to
right. Does anyone know how to select them in order?
 
Are you trying to make it so that you have a list of things that the user can
choose from? Maybe I don't understand what you're trying to do, but it seems
that you would be better off just using a listbox where the user can select
one or more than one item(s) in the list, with the listbox rowsource set to
the values you want to select from.
 
I am trying to create something that looks like an address book with the tabs
on the side. The tabs are created when the form is opened based on the
company field of an info database, and filter a list box that each record of
the list box can be selected to open a form to get/edit all the info I have
it working on pre programmed buttons in a group box. but that doesn't allow
for new enteries.
 
Back
Top