close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()