Form Creation

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello is there a way I could have three combo boxes which
look at each other and produce and end result...

For this I would need somethig like the folowing...

Combo1 has the values of Male or Female
Combo2 has the values of Q1,Q2,Q3 etc up to Q25..
Combo3 has the values of true or false

A text box which adds up the no of records based on teh
above data in a percentage?

Thanks

James
 
Hello is there a way I could have three combo boxes which
look at each other and produce and end result...

For this I would need somethig like the folowing...

Combo1 has the values of Male or Female
Combo2 has the values of Q1,Q2,Q3 etc up to Q25..
Combo3 has the values of true or false

A text box which adds up the no of records based on teh
above data in a percentage?
Click to expand...

What's the structure of your table? Combo boxes can be used as
criteria in a Query, and you can create a Totals query using those
criteria; for instance you could create an unbound Form named frmCrit
with combos cboGender, cboQ and cboYesNo (or just use a checkbox). You
can then create a Query using

=Forms!frmCrit!cboGender
=Forms!frmCrit!cboQ
=Forms!frmCrit!chkYesNo <or> cboYesNo

on the Criteria line; change it to a Totals query using the Greek
Sigma icon to calculate your sums and percentages (I can't say just
how you'ld do this because I don't know what you're summing).
 
Hello...

Ok I have

1 table... Which has the following in:

Are you male or Female With a value list as an answer....

Then Q01 with a value list of true or false....
Then Q02 As above...
All the way through to Q25....

Now how do I create this query?? I have a text box which
is where I will have the total... Basically do I need to
create a query??? If so please could you assist me with
the createtion of that. I would like it to take the values
of the 3 combo boxes... and then look through the records
with that matching criteria and then give me the total
records it has found in the text box.

Does this help any?

Thanks

James
 
Back
Top