Subform and Combo Box question

B

buzzybee328

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!!!!!!
 
P

Penguin

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

SteveS

buzzybee328 said:
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!!!!!!
Click to expand...


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

msvp.org/access

and

http://rogersaccesslibrary.com/TableOfContents3.asp


HTH

Steve
 
B

buzzybee328

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!
 
P

Penguin

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

Me!MySubform.Requery

Change MySubform to the name of your subform.
 
Top