You might want to add a lot more details about what you want to accomplish, and any questions are welcome.
Hope that is enough info to go on. I really appriciate the help!
If the prices of all the items are all different, you can simply set the export value of each item in the combo box to the corresponding price. In the calculate event of the price field you would get the value of the combo box field, which will be the price, and set event.value to this value.
If two or more items will have the same price, you have to set up a lookup table, in which case you would not have to set export values for the combo box items. Post again if this is the case.
Do you also want to automatically populate the description field as well based on the item code?
Possibly. At this point though I would really just like to get this working. I do have another question though. Would it be possible for the user to be able to edit the price field? In other words, if there needed to be a price adjustment but it still applied to the corresponding item number for which the value was already set.
1 person found this helpful
Since it's a possibility, let's do it right from the beginning. A great way to learn more about this is to read through the two-part article by Thom Paker on programming combo boxes:
Study these and see what you come up with. Post again if you need more help.
Regarding the price field, it is possible to set up the price field so that the user can override the value that's automatically calculated, but it's safe to leave that until you have the rest of it working. I'll be happy to demonstrate how it's done then.
Thanks, that's pretty close to what I'm looking for. Although I have a rough idea of how some of the scripting works I'm more confused on where to enter the script at I guess.