By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,508 Members | 2,904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,508 IT Pros & Developers. It's quick & easy.

subform won't display as datasheet

P: n/a
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
Jan 23 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.


Jan 23 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.