3) Next post, I need to know the name of your new subform

Private Sub tabCtl1_Change()
Dim strSQL As String
Dim iTab As Integer
MsgBox "Tab chosen is " & TabCtl1.Pages(TabCtl1).Name
iTab = Mid(TabCtl1.Pages(TabCtl1).Name,

Private Sub tabCtl1_Change()
Dim strSQL As String
Dim iTab As Integer
MsgBox "Tab chosen is " & TabCtl1.Pages(TabCtl1).Name
iTab = Mid(TabCtl1.Pages(TabCtl1).Name, 4, 1)
strSQL = "SELECT * FROM Material WHERE matTypeID="

SELECT * FROM Material WHERE matTypeID=2 ORDER BY material;

SELECT MixSample.DM_Mix, MixSample.DM_MaterialNo, MixSample.matTypeID, MixSample.materialID, MixSample.matBatchWeight, MatType.matType, Material.material, Material.materialGrav,

I'm assuming that your tab page names now contain the matTypeID in them.  The above code assumes in position 4, i.e. "mat3"

Message boxes become annoying.  Quickly.  Although they never quit being annoying, they become ignored.  The click-a-tab / click-a-OK becomes automatic.  But it

=[SF_CementType].[Form]![txtWaterBW]

I have cleared out all code telling my tabs to appear visible or invisible, yet when I open my form, it still only shows the one cement tab.

I am still not sure category is in the table structure. Are you using "material type" and "category of material type" to mean the same thing?

Why did you change your record source to include the combo value? The record source for each subform should not change

Private Sub matTypeID_AfterUpdate()
Select Case matTypeID
   Case 1
      Me.materialID.Requery

You are trying to code a problem that has not been clearly defined, and the rules seem to change with each post.

Note: The code in Post #8 will hide ALL TABS after 2 calls to the subroutine.

Select Case matTypeID

   Case Is = 1
TabCtl1.Pages(1).Visible = False
TabCtl1.Pages(2).Visible = False
TabCtl1.Pages(3).Visible = False
TabCtl1.Pages(4).Visible = False

   Case Is = 2
TabCtl1.Pages(0).Visible = False