combo help please

I may be going about this the wrong way, if I am please tell me. I am trying
to run two combo boxes, both run off a single query that does both
calculations. One is Qualifying cost (QC). The other is State Financial
Participation (SFP). The query does the calculations fine. I have to enter a
Wealth index, a Means value, and a POR then I want the query to run,
calculate QC and SFP, and then display those values in the combos. I have
tried requery commands on both combos, and on the last item to be entered
(POR). The row source of the combos is correct but it is not giving me the
answer until I click inside the combo. Am I all wet, need to do it
differently, or missing something? Thanks so much!!!!!
--
Milton Purdy
ACCESS
State of Arkansas

Milton -

I sounds like you have the right row sources, as you are getting the
information in the combo boxes after you click. That means you probably just
need a Me.comboboxname.requery at a point after your queries run.

--
Daryl S


"golfinray" wrote:

I may be going about this the wrong way, if I am please tell me. I am trying
to run two combo boxes, both run off a single query that does both
calculations. One is Qualifying cost (QC). The other is State Financial
Participation (SFP). The query does the calculations fine. I have to enter a
Wealth index, a Means value, and a POR then I want the query to run,
calculate QC and SFP, and then display those values in the combos. I have
tried requery commands on both combos, and on the last item to be entered
(POR). The row source of the combos is correct but it is not giving me the
answer until I click inside the combo. Am I all wet, need to do it
differently, or missing something? Thanks so much!!!!!
--
Milton Purdy
ACCESS
State of Arkansas