Another form, 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!!!!!!

 

[John Vinson]

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

What do you want to "populate" the subform WITH?

You could give us some help navigating through the darkness here by
answering a few questions:

- What is the Recordsource property of the form? of the subform?
- What is the Rowsource property of the combo box?
- What information do you want to end up in the subform?

John W. Vinson[MVP]

 

[Guest]

Hi John,

I'm in the housing industry, so everything I work with relates to that. I
have a query I've titled qrySupplyBase. The fields in the query are
Submarket, TCG, HouseInv, VDLInv, Futures, and LotsLeft. I've specified
[cboSubmarket] in the Submarket criteria so that this is what the combo box
asks me for. The goal is to drop down the combo box to the correct Submarket
and get a listing of HouseInv, VDLInv, Futures, and LotsLeft for each TCG.
I created a frmSupplyBase and a sfrmSupplyBase. I inserted the
sfrmSupplyBase into the frmSupplyBase and I think that's where the problem
is. Right now I can drop down the combo box in frmSupplyBase, and nothing
shows up in the subform. However, the subform works correctly by itself.

Here are the answers to your questions:

record source property of the form: blank
subform: qrySupplyBase
rowsource property of the combo box: SELECT [qrySubMarkets].[SubMarket] FROM
qrySubMarkets; (there is an additional table that provides the SubMarket)
information in subform: see above. I want qrySUpplyBase to display with the
right records.

Thank you sir!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I really appreciate your
help.