Subform Which view

[Derek]

Hi All

I have a subform and I want to display all the records from a query in the subform so that the users can see all the records and make changes in that.

SO the subform will display the Question names and there will be 3 radio buttons for score and the score needs to be updated. The Score frame will have Yes,No and N/A radio buttons. Then the next control is Notes section that the users need to fill up. All the controls are bound.

My problem is I am not able to change the score or type anything in Notes section. It doesn't let me make any changes.

What is the best way to display all the Questions and Yes/No/NA radio buttons and Notes section that they can update ?

As its the call Audit form so when the auditors will be listening to a call then they will be ticking the appropriate radio button next to each question and will write down the comments.

Can you please let me know which subform view I should use? Shall I use subform or something different to achieve this. Please see attached my subform.

Thanks.

 

[Uncle Gizmo]

I'm not sure if I've got the right end of the stick with your question, but I thought I should point you to this:- https://sites.google.com/site/msaccess457966vmfjg/advanced-techniques/check-lists which you can look and see if it's of use or not..

 

[JHB]

..
My problem is I am not able to change the score or type anything in Notes section. It doesn't let me make any changes.

Are you able to make any changes direct in the subform's query?

 

[Derek]

Guys, What is the best way to display all the records in the subform with the scrollbar if they don't fit in the subform. WHn I am saying records then it means Just Questions column values from the query and then Yes,No N/A radio buttons with all the Questions and Notes section too .
Which subform view I need to use for that? As if I use datasheet view then the radio buttons don't get displayed. If I do single form then only one record gets displayed at a time. If I do continuous then again we can't see all the Questions at the same time.

Any help will be much appreciated.

Thanks

 

[Derek]

Hi All, My subform is now working fine and its updateable. My question is how can I display all the records on the subform? can anyone pls help me in this?

thanks

 

[JHB]

Set the form view as "Continuous Forms" and make the detail section as small as you can.
Else post your database with some sample data + the name of the form, zip it.