So I've been playing with combo boxes and subforms.
Finally, I can make a selection in a combo box, and have that drive an
after update event to open a query or a form.  Works famously.

Now the next step is to bury the form in the same form where the cmb
is located (as a subform)

I use two linked cmb.  And I have linked the second cmb with the
subform.  A selection in the first cmb limits the selection in the
second cmb. A selection in the second cmb drives the form (or qry
actually).

When I make a selection in the cmb's, the info in the subform
changes..as expected.  But the subform only shows data  when I have
the form format property set to single or continuous forms.  If I set
it to datasheet no data shows up.
What am I doing wrong?

Here is the VBA I'm using for the two cmbs

Private Sub cmbCREATORSELECT_AfterUpdate()
Me.cmbEXPTSELECT = ""
Me.cmbEXPTSELECT.Requery
End Sub

Private Sub cmbEXPTSELECT_AfterUpdate()
Me.frmEXPTINFO.Requery
End Sub

frmEXPTINFO is based on qryEXPTINFO that is limited where [CREATOR]=
cmbCREATORSELECT

[CREATOR] and [EXPTNAME] are fields in the qry.

Do you need any other info to help?

Thanks
Jerry