Form-Subform list fields question

N

Nemo

Hi All,

having a form, containing a subform, is it possible to display all the
fields in the subform as a list, as follows?
--------------------------------------------------
SurveyForm
Date
Teacher (combobox)

QuestionsSubForm
Question1 = Mark (combobox)
Question2 = Mark (combobox)
Question3 = Mark (combobox)
Question4 = Mark (combobox)
Question5 = Mark (combobox)
etc
--------------------------------------------------

I must specify that the subform is already set on continuous fields,
nevertheless I can see only one Question field plus mark combobox.

Surfing the net, in order to solve the problem, I found out a nice "AT YOUR
SURVEY" Access database from Dueane Hookom a Microsoft Access MPV, where
this is possible.

Did I miss something in building the database?
TIA
Nemo
 
G

Gina Whipp

Nemo,

I THINK my first message sent blank... that was an "OOPS" moment. Getting
past that... I think you should review the table structure of Duane's
database because it sounds like you set up your tables to...

Question1 - Question2 - Question3 - etc...

....which does make what you're trying to do difficult if not impossible in
continous form view. You would have to layout your form in Single form view
and place all the Questions on it to get what you are looking for.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
N

Nemo

Nemo,
I THINK my first message sent blank... that was an "OOPS" moment. Getting
past that... I think you should review the table structure of Duane's
database because it sounds like you set up your tables to...

Question1 - Question2 - Question3 - etc...

...which does make what you're trying to do difficult if not impossible in
continous form view. You would have to layout your form in Single form
view and place all the Questions on it to get what you are looking for.
Click to expand...

Hi Gina,
THANK YOU for your prompt replay and advice. Unfortunately, in this moment,
I'm having high fever and I'm upset. When I'll be a little bit better I
analyse the your post & link.
Thanks again for your help!!!
Warmest regards,
Nemo
 
N

Nemo

"Gina Whipp" ha scritto nel messaggio
Nemo.

Okie dokie... well FIRST, get better... I'll just wait to hear back!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
Click to expand...

Hi Gina,
now I'm fine and have a little bit freetime for my task.
Fist of all I must say that Access is the only MSOfficeApplication where I'm
not a "power user" unfortunately.
I analysed the Dueane Hookom Database and it's to complicated for me,
although the SurveyResponses Form is what I need.

My database is similar a Survey in a "School". A Teacher has many Students
(relation one-to-many) and each student in every class has to fill a Survey
to own Teacher.
What I need is a DataEntryForm with a combobox where the students can choose
their teacher and then a subform can display the questions with a small
combobox for the score.

Can you give more web-resources or link-url where a normal user can find
hints or help?
TIA

Nemo
 
G

Gina Whipp

Nemo,

Perhaps this is what you are looking for...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
N

Nemo

Gina Whipp said:
Nemo,

Perhaps this is what you are looking for...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
Click to expand...

Thanks Gina, I'll look into the matter.
Your Grocery DB is nice and the relation from the tables is simple, but I'm
not able to list the items.
Thanks for your help.
Cordially
Nemo
 
N

Nemo

Nemo,
Thank you...

I do not understand what you mean by list the items? What are you trying
to list?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
Click to expand...


Gina,
perhaps I made a step ahead.
I was able to list all the questions (in your Grocery DB are the items)
vertically in a frmQuestions....set by "continuous form view"
......now I have to made the final step in some where form, inserting the
above frmQuestions and a combobox called IDTeacher or Teacher.....of course
in the frmQuestions there is an "IDTeacher relation".

I hope in the near future to solve my task :)

Cordially,
Nemo
 
G

Gina Whipp

Nemp.

Is this a form/subform set-up or are you trying to do this on one form.
Also, how are teachers related to the questions? Unless I missed it, I did
not see where you provided your table set-up...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
N

Nemo

Nemp.
Is this a form/subform set-up or are you trying to do this on one form.
Also, how are teachers related to the questions? Unless I missed it, I
did not see where you provided your table set-up...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
Click to expand...

Sorry Gina,
maybe in my previous post, I didn't explain clearly the tables
relation.....they are set in this way:

tblTeacher
IDTeacher (Counter)
Teacher (Text)

tblQuestion
IDQuestion (Counter)
Question (Text)
Score (Text)
IDTeacher (Numerical)

The two tables are linked/related from *tblTeacher.IDTeacher* and
*tblQuestion.IDTeacher* - with relation one-to-many

Now I have to build the Main Form having a Teacher combobox and the
subfrmQuestion with all the questions vertically listed.

Of course, between the main form and the sunform must be a refresh, ....I
have the sensation to be close to the solution.

Cordially,
Nemo
 
G

Gina Whipp

Nemo,

I think part of your problem is the table set-up...

tblTeacher (This would be the combo box on the main form)
IDTeacher (Counter) - PK
Teacher (Text)

tblQuestion
IDQuestion (Counter) - PK
Question (Text)
Score (Text) - REMOVE
IDTeacher (Numerical) - REMOVE

tblResults (This would be the subform)
IDQuestion - FK
IDTeacher - FK
Score

I think you should review some of those resource links I sent. You seem to
be skipping past the basics to design. Kinda like hanging the light
fixtures before the foundation is even complete.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 

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

Filling out an existing word document form from an external source 1
Query in a sub form 1
Opening a form using combo & multiselect list box data 1
Form/Subform Problem 1
ComboBox on subform - limit to list can be overridden? 5
Requery Subform ComboBox from Other Form 3
combobox & Subform 4
Form Questions 5

Top