Subform and Combo Box question

[Guest]

Hi! I'm hoping someone can help me even though they can't see my database.
I've got a base form with a combo box and a subform in it. The goal is to
have the choice from the combo box populate my subform through the query, but
it's not working. The subform just sits there and doesn't do anything. I'm
not sure what I'm missing, and this is my first go at it.
I started by developing a query, then a form, then sticking a subform in
that form. Someone please help or point me in the right direction! Maybe
there are some pages out on the net about how I can do this. Thanks!!!!!!

 

[Penguin]

Have you tried requery on the subform after a selection is made from
the combo box?

 

[Guest]

Hi! I'm hoping someone can help me even though they can't see my database.
I've got a base form with a combo box and a subform in it. The goal is to
have the choice from the combo box populate my subform through the query, but
it's not working. The subform just sits there and doesn't do anything. I'm
not sure what I'm missing, and this is my first go at it.
I started by developing a query, then a form, then sticking a subform in
that form. Someone please help or point me in the right direction! Maybe
there are some pages out on the net about how I can do this. Thanks!!!!!!

Two excellent sites that I use all of the time are:

msvp.org/access

and

http://rogersaccesslibrary.com/TableOfContents3.asp


HTH

Steve

 

[Guest]

Hi! No, I haven't tried that. How do I do that? I'm ignorant when it comes
to combo boxes and subforms. I'm hoping to work through that. thanks!

 

[Penguin]

In the AfterUpdate property of the combo box place this code:

Me!MySubform.Requery

Change MySubform to the name of your subform.