>Here is the senario:
>
>I wish to have a combo box (ie Vendor Type) come up with a list of available Vendor Types, however if the user wishes to add a new type they would be able to type it in and it would be added to the list (appended to the vendor type table).
>
>The combo box is based on the table: v_type
>Fields:
>vtyp_cd (code)
>vtype_nm (name)
>
>Can anyone help?
>additional email: davidm@orcatec.com
I have a combo I use that allows the user to maintain the RowSource data file by RightClicking on it. It is in a form I understand but I probably could gin up some instructions and give it to you.
RightClick brings up a menu with Add, Edit, Delete, General Maintenance & Cancel for choices. A maintenance form of your design ( from my template ) is then called and performs the maintenance on the table.
Please be aware though as you have probably seen from other messages on the forum lately - YOU MUST MAKE SURE YOUR ROWSOURCE TABLE IS NOT READ ONLY IN THE STARTING FORM.
Let me know
Terry
It is impossible to make programs idiot proof. Idiots are too cleaver.
MCP( Tcp/Ip )