Combination boxes allow editing or data entry correct? List do not -
correct? I need to be able to edit the table that I get my list information
from is that possible? Also when an item is chosen from the list - a
particular product - I need the price of that product to be entered into the
price column. I have found many one to many list but I just need to do a 1
for 1. Is the easiest way to set up a bunch of quot;IFquot; statements? I also need
to know how to delete a combo box. I had one that was no problem to remove
but I can't get rid of the other one.
Marc
you cant edit a drop down directly,but if you know where the source list is
you can edit that.....Use a vlookup table based on your source list to do
your pricing.However if you edit or add an entry you will have to edit or
update or add a price.You will also have to use a false vlookup because your
editing of the list would upset the sort order.This means the vlookup
function will only find exact matches,but that isnt a problem because the
lookup and source lists are identical.....
here are editable drop downs and list boxes in the forms toolbar but they
have never been available ....
--
paul
remove nospam for email addy!
quot;Marcquot; wrote:
gt; Combination boxes allow editing or data entry correct? List do not -
gt; correct? I need to be able to edit the table that I get my list information
gt; from is that possible? Also when an item is chosen from the list - a
gt; particular product - I need the price of that product to be entered into the
gt; price column. I have found many one to many list but I just need to do a 1
gt; for 1. Is the easiest way to set up a bunch of quot;IFquot; statements? I also need
gt; to know how to delete a combo box. I had one that was no problem to remove
gt; but I can't get rid of the other one.
gt;
gt; Marc
gt;
gt;
gt;
- Dec 25 Tue 2007 20:41
Questions on combo boxes and list boxes.
close
全站熱搜
留言列表
發表留言