how do i link 2 or more combo boxes
for example if i choose smoked salmon from the combo box i want the unit price, case price (these to are in the table) and the case size (is in a combo box) to automatically to come up but as this is a reordering system i also to minus the case size as this is the amount selling and then use a command button to isert this into the database (so it can be up to date) but i can't change anything in the programming as this in excel thats the rule
i'm sorry if this confusing, it is to me
i appreciate the help thank you
for example if i choose smoked salmon from the combo box i want the unit price, case price (these to are in the table) and the case size (is in a combo box) to automatically to come up but as this is a reordering system i also to minus the case size as this is the amount selling and then use a command button to isert this into the database (so it can be up to date) but i can't change anything in the programming as this in excel thats the rule
i'm sorry if this confusing, it is to me
i appreciate the help thank you