subform won't display as datasheet

[jerry.ranch]

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

[jerry.ranch]

Never mind people
Suddenly it started working properly.
God only knows what I did
Jerry
On Mon, 23 Jan 2006 12:12:40 -0600, je*********@pioneer.com wrote:

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.