Form
in [Forms]
|
Prev: DLookup
Next: Input mask
From: Iram on 23 Apr 2010 12:15 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
From: Amy E. Baggott on 23 Apr 2010 13:13 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. -- Amy E. Baggott "I''m going crazy and I''m taking all of you with me!" -- Linda Grayson "Iram" wrote: > 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
From: Mike Painter on 23 Apr 2010 15:31 Iram wrote: > 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.
From: Iram on 23 Apr 2010 16:20 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 "Mike Painter" wrote: > Iram wrote: > > 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. > > > . >
|
Pages: 1 Prev: DLookup Next: Input mask |