Subform with a list

[sajarac]

Hello there,

I have been trying to figure out this, with no luck so far.

currently I have 50 items that belongs to an assessment questionnaire, and I would like to have those 50 items listed in a subform rather that pick or choose an item from the drop down menu, please see enclosed file, is this possible? if so any guru can point me out in the right direction?

Thank you kindly.

 

[Ranman256]

you have a master tbl, tQMaster and master record, "Questionaire123"
then in the child table, tQChilds, add the 50 questions in the sub table,
either by picking/choosing (like the photo)
or
use a pick list from tbl, tQuestions, that has all possible questions.
and a 'temp' tPIcked items to hold the chosen items.
2 list boxes on a form. lstSource has all possible questions
lstPicked, shows whats in tPicked.
Then when all items have been picked , run an append query to add tPicked to tQChilds tbl.

A dbl-click on the list box would launch an append query to tPicked.

 

[RuralGuy]

I'm not sure I understand your desire. Do you want *all* 50 to be listed in the SubForm? If so, what is the RowSource of the ComboBox in the Product field?

 

[sajarac]

Thank you very much guys for your prompt reply. I don't want a combobox in my subform I want to see my 50 items in the subform, because every item has a different values like size, width, etc

 

[sajarac]

You are absolutely right, I'am going to try your "0 - Adding a Checklist to MS Access".

I will keep you posted with the results, thank you very much Master....

Best Regards

Sajarac

 

[yupstrips01]

thanks for sharing this info

 

[sajarac]

Thank you Mr Uncle, Just watched your videos, really nice and you are right that is exactly what I am looking for. But just a quick question, for a new guy, a dummy in the access world is there any other option a little bit easy? I am trying to do it but then I get stuck.

Thank you very much for your response.

Regards

Sajarac