Reloading a Form

[gary.newport]

I realised that my last post was very textual and unclear but could not think of a way of clearly conveying the issue. I now realise that all my data is test so reveals nothing; therefore I have attached the database zipped up.

The two forms I have an issue with are frm_gradebook and frm_unit_results. I want to alter the data being shown in the latter by selecting items in the former. I cannot place the latter as a subform since the crosstab query it is based on has varying column counts.

Is there any way that I can have this work?

Also, the fields in frm_unit_results cannot be altered. Is it possible to make them editable and save to the relevant tables?

 

[JHB]

Also, the fields in frm_unit_results cannot be altered. Is it possible to make them editable and save to the relevant tables?

NO - result from a cross tab query can't be edit.

 

[gary.newport]

yep, I got that thank you.

So now I have hit a significant problem. I want the user to be able to click the tick boxes and so record changes for each of the students. The form I have works well but I cannot use it as either a subform or as an editable system. I could have an EDIT button to the side but this now makes the system more difficult to use.

I am wondering how best to do this. The number of tickboxes and labels needs to vary depending upon the data in the table tbl_gradebook; as does the captions of the labels - that is what my code does.

Do I create via code the recordset based upon the tables that the subform then uses; then requerying the subform as needed?

Do I have the form, on load, create a temporary table whose content changes as the Units dropdown changes? How would the number of labels and tickboxes then change?

What else can I do? Really lost for answers at this stage.

 

[gary.newport]

One quick question; if I did go for an edit button that opened a new single record form that allowed me to edit that specific record, is it possible to have a NEXT button that would allow the form to load the data for the next student as shown on the subform?