Combo Boxes

[Deb Struble]

In my form I have a combo box that pulls the list from Table A. The value
selected is then stored in the referencing field in Table B. I would like
the user to be able to update the list in the combo box so I set the limit
to list property to 'No'. This allows the user to be able to enter a new
list item but it doesn't store the new item in Table A so it can be used in
the drop down again. Any ideas on how I would set up that functionality?
Thanks!

 

[Jonathan Parminter]

Deb wrote:...

-----Original Message-----
In my form I have a combo box that pulls the list from Table A. The value
selected is then stored in the referencing field in Table B. I would like
the user to be able to update the list in the combo box so I set the limit
to list property to 'No'. This allows the user to be able to enter a new
list item but it doesn't store the new item in Table A so it can be used in
the drop down again. Any ideas on how I would set up that functionality?
Thanks!

Hi Deb,
set Limit to list to 'yes'
position the cursor in the event property 'not in list'
and then press F1. Use the online help for an example to
add the new value to table A and update the combobox.

Luck
Jonathan