Option Buttons and Combo Boxes

[Sharad]

I have a Data collection program that has option group with 2 buttons. Say, Retail and Wholesale.

When I choose Retail option than the combo box should populate from tblRetail by using the drop down menu. Once the selection is made from the tblRetail and other fields are entered Save button populates tblOrderRetail.

When I choose Wholesale option than the combo box should populate from tbWholesale by using the drop down menu. Once the selection is made from the tblWhole and other fields are entered Save button populates tblOrderWholesale.

To make myself clear. I have 2 table to be read from and 2 tables to be written to. Option Buttons to choose which one it will read from and write to.

It seems confusing but can explain further if need be. How would I go about doing that ? Any help would sure be apprecited. Thanks...sharad

 

[crosmill]

OK, a bit out of my league (in the way that I've never done this beofre) but what I think you need to do is to create a function that creates the combo box, or a least it's values, but dependant on a variable passed to it from the form.

Obviously depending on the variable, the function would process different parts of the code.

One other thing, I think I'm right in saying that the combo box will only populate OnLoad so you may have to pass the variable from another form.