A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Checkbox that pulls related info from form to report



 
 
Thread Tools Display Modes
  #1  
Old February 11th, 2010, 08:00 AM posted to microsoft.public.access.gettingstarted
Chantel33
external usenet poster
 
Posts: 23
Default Checkbox that pulls related info from form to report

I have a table which has a questionnaire field and a question that relates to
that questionnaire name. I would like to create a form that users can choose
which questions they want on the questionnaire by checking the button next to
the type of questionnaire. I would like the results to output to a report.
Please help
  #2  
Old February 11th, 2010, 11:31 PM posted to microsoft.public.access.gettingstarted
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Checkbox that pulls related info from form to report

I'm not sure anyone can help without guessing. Can you provide your table
structure? Are your tables normalized?

If the tables are normalized, i would think you could create a multi-select
list box and use it as the criteria to print a report of the selected
records/questions from the list box.

--
Duane Hookom
Microsoft Access MVP


"Chantel33" wrote:

I have a table which has a questionnaire field and a question that relates to
that questionnaire name. I would like to create a form that users can choose
which questions they want on the questionnaire by checking the button next to
the type of questionnaire. I would like the results to output to a report.
Please help

  #3  
Old February 15th, 2010, 08:16 AM posted to microsoft.public.access.gettingstarted
Chantel33
external usenet poster
 
Posts: 23
Default Checkbox that pulls related info from form to report

I am very new to this, i guess it is normalized!

tbl(questionnaires):
Field 1 - type of questionnaire (ex. DM, HTN, AST)
Field 2 - Question relating to that Questionnaire

Questionnarie could have 2-3 questions realted to it, i would like to create
a form that will merge questions into the report, once the checkbox to that
questionnaire is selected. I would like a section where you choose DM and
the DM questionnaires auto populate. Is this possible

Duane Hookom" wrote:

I'm not sure anyone can help without guessing. Can you provide your table
structure? Are your tables normalized?

If the tables are normalized, i would think you could create a multi-select
list box and use it as the criteria to print a report of the selected
records/questions from the list box.

--
Duane Hookom
Microsoft Access MVP


"Chantel33" wrote:

I have a table which has a questionnaire field and a question that relates to
that questionnaire name. I would like to create a form that users can choose
which questions they want on the questionnaire by checking the button next to
the type of questionnaire. I would like the results to output to a report.
Please help

  #4  
Old February 15th, 2010, 09:51 AM posted to microsoft.public.access.gettingstarted
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Checkbox that pulls related info from form to report

"checkbox to that questionnaire"? Where is this from? Is it bound to a field
in a table?

Can you please describe your significant tables and fields?

Duane Hookom
MS Access MVP

"Chantel33" wrote in message
...
I am very new to this, i guess it is normalized!

tbl(questionnaires):
Field 1 - type of questionnaire (ex. DM, HTN, AST)
Field 2 - Question relating to that Questionnaire

Questionnarie could have 2-3 questions realted to it, i would like to
create
a form that will merge questions into the report, once the checkbox to
that
questionnaire is selected. I would like a section where you choose DM and
the DM questionnaires auto populate. Is this possible

Duane Hookom" wrote:

I'm not sure anyone can help without guessing. Can you provide your table
structure? Are your tables normalized?

If the tables are normalized, i would think you could create a
multi-select
list box and use it as the criteria to print a report of the selected
records/questions from the list box.

--
Duane Hookom
Microsoft Access MVP


"Chantel33" wrote:

I have a table which has a questionnaire field and a question that
relates to
that questionnaire name. I would like to create a form that users can
choose
which questions they want on the questionnaire by checking the button
next to
the type of questionnaire. I would like the results to output to a
report.
Please help


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.