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

Never mind people
Suddenly it started working properly.
God only knows what I did
Jerry


On Mon, 23 Jan 2006 12:12:40 -0600, jerry.ranch@pioneer.com wrote:
[color=blue]
>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.[/color]