Editable combo box? possible?

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

Is it possible in some way to allow a user to ADD a value to a drop-down
menu combo box which is either being populated from a linked/joined table or
list?

Thanks
jason
 
Jason,

If you set the LimitToList property to No you can add a different item than
is in the list, however this will not permanently add it to the List, just
to that record. To see it in the list in the future, you need to actually
add it to your list or the lookup table and then Refresh the form.

Gary Miller
 
Hi Gary,

This is my dilemma:

I need to be able to give the user the ability to add a value to the LOOKUP
table on the fly....

How do you give the user this ability - is there a way?
 
Jason,

What I usually do is to put a tiny command button next to the ComboBox that
just has a "+" sign on it. When they click that I bring up a popup form that
allows them to add records to the LookUp table. When the form closes I put
in a call to refresh the original form so that it will now show the new item
in the list. I do this with a line like...

[Forms]![YourFormName].Refresh

.... in the OnClose event of the popup form.

Gary
 
Great - it works perfectly - except that I find the size of the popup form
via Docmd. is too big....is there any way to control the size of the window
and prevent the user resizing it?

Thanks
Jason
Gary Miller said:
Jason,

What I usually do is to put a tiny command button next to the ComboBox that
just has a "+" sign on it. When they click that I bring up a popup form that
allows them to add records to the LookUp table. When the form closes I put
in a call to refresh the original form so that it will now show the new item
in the list. I do this with a line like...

[Forms]![YourFormName].Refresh

... in the OnClose event of the popup form.

Gary

jason said:
Hi Gary,

This is my dilemma:

I need to be able to give the user the ability to add a value to the LOOKUP
table on the fly....

How do you give the user this ability - is there a way?
Click to expand...
Click to expand...
 
Back
Top