D
Daiuy
I have an combo box that populates the SECTION and PHONE text boxes based
upon the LASTNAME the user selected from the combo box. I eventually hope to
make the NAME field a concatenation of RequestorLast and RequestorFirst.
My immediate problem is that I need to allow new names to be entered in the
combo box.
I tried changing the LIMIT TO LIST property to NO.
Once I do that and type in new LASTNAME in the combo box I can't make any
entry in the following text boxes because there control source is
=ComboName.column#.
I believe I need code in the AfterUpdate event of the combo box that
evaluates the combo box value:
If the combo box value is already in the list, then fill the following text
boxes with the appropriate column data.
Else, display a message box asking if the new value is to be stored.
If yes then separate the firstname from the last name, store each in the
appropriate field as a new value and allow the SECTION and PHONE text boxes
to be edited.
I'm also thinking that perhaps I could use the combobox's NOTINLIST event to
do the initial evaluation and store the name. My question then is how to
allow edits in the SECTION and PHONE text boxes.
Thanks in advance,
Daiuy
upon the LASTNAME the user selected from the combo box. I eventually hope to
make the NAME field a concatenation of RequestorLast and RequestorFirst.
My immediate problem is that I need to allow new names to be entered in the
combo box.
I tried changing the LIMIT TO LIST property to NO.
Once I do that and type in new LASTNAME in the combo box I can't make any
entry in the following text boxes because there control source is
=ComboName.column#.
I believe I need code in the AfterUpdate event of the combo box that
evaluates the combo box value:
If the combo box value is already in the list, then fill the following text
boxes with the appropriate column data.
Else, display a message box asking if the new value is to be stored.
If yes then separate the firstname from the last name, store each in the
appropriate field as a new value and allow the SECTION and PHONE text boxes
to be edited.
I'm also thinking that perhaps I could use the combobox's NOTINLIST event to
do the initial evaluation and store the name. My question then is how to
allow edits in the SECTION and PHONE text boxes.
Thanks in advance,
Daiuy