Value of List Box in Text fields on Form

G

Guest

I have a multiple select List box that the user will potentially click on 10
items from the List Box. I want to be able to drop the results of each item
clicked in a text field on the form.. so the first item clicked would go in
the first text box, second would go in the second text box.. is this possible?

Thanks.

Lisa
 
G

Guest

Possible - yes, but what are you trying to achieve?

If you really want to have multiple choices in separate fields you would
probably be better off using combo boxes on those fields.

Why are you doing this?
I suspect there may be a better way...

Steve
 
J

Jeff Boyce

Lisa

You've described a "how" ... how you want to accomplish something. If
you'll provide a bit more information about what the underlying data looks
like (i.e., structure), and what business need having a screen full of
filled text boxes will serve (i.e., "why"), the folks here in the newsgroup
may be able to offer an alternate approach that still meets your needs. Or
at least understand better the constraints you're facing before offering
specific suggestions...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
G

Guest

Here is my problem... a user fills out a form that has 25 questions and each
question has an option group (yes, no, na). Dumps the information into the
table.
I need a report where they choose the Site Lead and get a report that lists
each question down the left of the report, the Managers going across the top
(could be up to 10 managers) and underneath each manager the total number of
questions (answered yes or no) and also the percentages of yes's to the
total. The problem is that you can't run a report with the managers going
acros the top because you can't assign the column headings upfront because
depending on the Site Lead the Managers will change.

My thought was if they picked the managers from a list, I would be able to
run 10 individual reports and pull them together on one report based on each
manager they chose from the dropdown.

Sounds rediculous to do, but if you can think of a better way to do it i
would greatly appreciate the help.

Data Example:
Site Lead Manager Employee Q1 Q2 Q3 Q4 Q5 - Q25


Report Example:
Manager 1 Manager 2
Manager 3

Q1 Total Total Yes % Total Total Yes % Total Total
Yes %
 
G

Guest

You should be able to do that with a dynamic crosstab report.
Have you done that before?
You need some code in a Module that fills the report for you...

If your tables are set up correctly, you would just need to supply a Site
Lead ID to the query. Up to you, either use a global variable and get the
value with a Function or change the QueryDef before calling the report.

Steve
 
G

Guest

I can do the crosstab (not sure about a dynamic crosstab).. In the crosstabs
i know how to do you have to provide the column headings which would be each
manager under the Site Lead.. and they will be different every time based on
the Site lead.

Make sense?
 
G

Guest

Yes, you will need a dynamic crosstab for that.
All the fields on the report with exception to the Question field in your
case, will be unbound. The code in a module fills the report fields at
run-time.

I'm not sure if you can get an example of this from one of the MVP sites.
I've never tried since I have my own...

If you want to give me a temp email address, I'd be happy to send you an
example.

Steve

Steve
 
G

Guest

if you can send it both of these (e-mail address removed) and
(e-mail address removed) That would be great.

Thanks.

Lisa
 
G

Guest

Jeff,

Thanks for you response. I gave a little more information in my second
response to steveM.. here is what I need

Here is my problem... a user fills out a form that has 25 questions and each
question has an option group (yes, no, na). Dumps the information into the
table.
I need a report where they choose the Site Lead and get a report that lists
each question down the left of the report, the Managers going across the top
(could be up to 10 managers) and underneath each manager the total number of
questions (answered yes or no) and also the percentages of yes's to the
total. The problem is that you can't run a report with the managers going
acros the top because you can't assign the column headings upfront because
depending on the Site Lead the Managers will change.

My thought was if they picked the managers from a list, I would be able to
run 10 individual reports and pull them together on one report based on each
manager they chose from the dropdown.

Sounds rediculous to do, but if you can think of a better way to do it i
would greatly appreciate the help.

Data Example:
Site Lead Manager Employee Q1 Q2 Q3 Q4 Q5 - Q25


Report Example:
Manager 1 Manager 2
Manager 3

Q1 Total Total Yes % Total Total Yes % Total Total
Yes %
 
G

Guest

Example sent. Create a crosstab query with Question as RowHeading and Manager
as ColumnHeading. Bind the one field (txt62) to the Question field. Name the
query the same as the report.

You can use the fields in the report footer for calculations etc...

Not sure it will give exactly what you are looking for but I think it will
get you close.

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form - Lock Fields from Editing 0
Multi-Select LIst Box Not Appearing in Text Box 2
Open record from List box 1
Can a Check Box Prevent Other Fields from Being Used? 1
Value list updates not appearing in form 1
Combo Box control with keyboard keys 4
auto populate text box based on combo box value 1
Search Unbound Column in List Box 5

Top