Help with Data Entry Form

[DuWayne]

Help with Data Entry Screen
Have Tables
tbl_BaseMaterialData------This data on my main form Frm_DataIn
HeatCodeID
Code
TestNo
DateofTest
Size
Wall
MatlType
HtNo
MatlSpec
MatlMfg

tbl_TensileBase------------This data on subform SubFrm_TensileBase
TensileBaseID
B-TestNo
B-DateofTest
B-Yield
B-Tensile
B-Elong
B-Xeul
B-ReducedArea

tbl_TensileWeld-------------This data on subform SubFrm_TensileWeld
TensileWeldD
W-TestNo
W-DateofTest
W-Yield
W-Tensile
W-Elong
W-Xeul
W-ReducedArea

tbl_TypeofTest-------------This populates the combobox has no ID key
Base
Weld

My subform are setup in continuous with each subform I added a combobox
at the beginning of each that uses TypeofTest.

What I want is when I chose either Base or Weld, I want the data to go to
that
particular table. How do I do it?
Thanks

 

[Guest]

one simple method is to give the choice to the user.... Have a "Select
Method" label and offer them 2 buttons "Base" "Weld"

and then the button opens up a form based upon that criteria....