Form

[Iram]

Hello,
I am using Access 2003.
I have a form with a subform. In the subform I have the following fields...
StatDate, Case#, Category, SubCategory, Notes and Amount.
The Category field currently has a combobox with a looonnnngggg list of
selections. I would like to change the category field to a text box and make
it so that On Focus it would pull up a seperate form called
frm_CategorySelections that would have all of the selections in a nice
formatted manner so that the user can select one of the selections on the
form and the form would save that selection back to the Category field. Is
this possible? If so would I have to make all of the selections in the
frm_CategorySelections screen into radials and group them using the radial
grouping buttons?

Is there an article out there that describes in detail how to do this or
would you be able to tell me how to do it over this newsgroup?
Your help is greatly appreciated!

Thanks.
Iram/mcp

 

[Amy E. Baggott]

One way to do it would be to put the choices in a list box and set the list
box's After Update event to something along the lines of

Me.TextBox = Me.ListBox (where TextBox is the name of your text box field
and ListBox is the name of your list box field)

The list box will allow the user to scroll through the choices and click on
one.

 

[Mike Painter]

Hello,
I am using Access 2003.
I have a form with a subform. In the subform I have the following
fields... StatDate, Case#, Category, SubCategory, Notes and Amount.
The Category field currently has a combobox with a looonnnngggg list
of selections. I would like to change the category field to a text
box and make it so that On Focus it would pull up a seperate form
called frm_CategorySelections that would have all of the selections
in a nice formatted manner so that the user can select one of the
selections on the form and the form would save that selection back to
the Category field. Is this possible? If so would I have to make all
of the selections in the frm_CategorySelections screen into radials
and group them using the radial grouping buttons?

Are the users familar with the categories?
If yes then all they have to do is start typing and the category will be
there, probably within four keystrokes. This is a major advantage over a
list box.
A separate form will require a *LOT* of work as all the fields will have to
be unbound since you will be placing multiple records on the form.

If there are a couple hundred or less and
if a good three letter or number key is assigned to the values and,
if the users use them a lot,
the chances are very high that they will learn most if not all of them in
short order and rarely need the combo box.


**********
I thought it was a fluke when a student testing a program for me learned
over 100 numbers related to classes in a short time. When the program was
finally put in use I found that everybody learned them in a very short time.

 

[Iram]

Thanks Amy and Mike for your feedback.
The reason why I need the selections on a form is because I want to break
down each selection into categories and I want to give the users a nice big
picture visual on all of the selections. The form will also allow me to type
notes next to the selections and put color formatting as well.

Would you still be able to help me in my quest to have a form populate a
field upon selection?



Thanks.
Iram/mcp