After a lot of searching and then even more trial and error, I made ADezii's very straightforward instructions in this post work for me.
http://bytes.com/topic/access/answer...oup-value-text
{Thank you so much ADezii. You have helped me so many times.}
However, I want to take this one step further.
I have an order form where people order plates in 6 different sizes. Those 6 sizes make my option group. However, many customers order two or three different sizes. So I have fields "Size1", "Size2", and "Size3" with 3 different options groups, but the options for the user to choose from on all three boxes are the same. My intent is to allow them to order 3 items on one form all at once. So I followed the directions here, but when I picked an option in OptionFrame2 Option Group, it only updated the Size1 box. (I understand why--because it's simply performing a match on the After_Update and the OptionFrameX is not really linked to SizeX in the code or properties.)
In case I'm not making sense, I want FrameOption1 to populate Size1 (with text, not a integer value), FrameOption2 to populate Size2, and FrameOption3 to populate Size3-----but remember, the six options are the same in all three option boxes.
Is it possible to extend ADezii's original train of thought here to fit my more complex needs? Or would we need to take a new approach? I'm a very basic user so simple is best. :-)
PS. If you are wondering why I would have an option group instead of a check box, it's because the order details for each size is different. A drop down would work as well but I think the option group is clearer for the user in my application.
Thanks in advance!!!