Prev: Copy a currency value from one control to another
Next: Default Path to the Desktop Folder
From: Iram on 29 Apr 2010 18:34
Hello.
I have a form with a subform (datasheet view). In the subform I have a few
fields, "Category", "SubCategory", "Amount", "Comments".

Upon clicking in the Category field I would like a form called
"frm_Categories" to open so that I can choose only one of many selections (
these selections would come from a table) so that upon choosing one of them
the form would grab what ever I selected and populate the "Category" field
with it.

Does anyone know how to do this?
I have seen something similar with a form calendar connected to a date
field. The form would populate the field with the selection from the calendar.

In this case I don't want to use a Combox because a form will allow you to
place the fields in a nice formatted way where as the Combox will make users
scroll for ever trying to find a selection.

Your help is greatly appreciated!

Iram/mcp
From: fredg on 29 Apr 2010 18:53
Regarding ... In this case I don't want to use a Combox because a form will
allow you to
place the fields in a nice formatted way where as the Combox will make users
scroll for ever trying to find a selection. ...

Actually, a combo box on a form is exactly the control that you want.
Set it's AutoExpand property to Yes and as the user starts to enter a name
it will jump ahead to the next value with that combination. There is no need
to scroll.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail



"Iram" wrote:

> Hello.
> I have a form with a subform (datasheet view). In the subform I have a few
> fields, "Category", "SubCategory", "Amount", "Comments".
>
> Upon clicking in the Category field I would like a form called
> "frm_Categories" to open so that I can choose only one of many selections (
> these selections would come from a table) so that upon choosing one of them
> the form would grab what ever I selected and populate the "Category" field
> with it.
>
> Does anyone know how to do this?
> I have seen something similar with a form calendar connected to a date
> field. The form would populate the field with the selection from the calendar.
>
> In this case I don't want to use a Combox because a form will allow you to
> place the fields in a nice formatted way where as the Combox will make users
> scroll for ever trying to find a selection.
>
> Your help is greatly appreciated!
>
> Iram/mcp
 | 
Pages: 1
Prev: Copy a currency value from one control to another
Next: Default Path to the Desktop Folder