I have a coboboxwith a list of products and a multiselect listbox "Countries". The price of the product varies (two variations) and depends of the country being chosen. This price and has its own field on form. Then it is calculated in discount and newprice field textbox.
And here is the problem. Because the records are filled only with one value from textboxes.
Is there a way to get the real values with related countries.
Almost everything works fine if i divide countries in two listboxes where only one combination exists.
I can add multiplyed records with one exception:
Every time I save records there is an empty record excpet autonumber field. I have made a query witch form is now based on and filtered this empty line out.
How to get rid of this?
Thanks
And here is the problem. Because the records are filled only with one value from textboxes.
Is there a way to get the real values with related countries.
Almost everything works fine if i divide countries in two listboxes where only one combination exists.
I can add multiplyed records with one exception:
Every time I save records there is an empty record excpet autonumber field. I have made a query witch form is now based on and filtered this empty line out.
How to get rid of this?
Thanks