I can't seem to get it to work. I've attached a copy of my database if you want to look and see what I've done wrong.
I am trying to get it so that when you select save choices on the options form you are given the option to print the choices you have just made in the options report.
If...
I've looked through the watch thing in the debug menu and have found something that says : Text : <You can't reference a property or method for a control unless the control has the focus.> : String : Form_Option Form.Command30_Click
will i have to focus back to student ID before I run the report?
I cant seem to get this to work.
Would it be any easier to output the selection to word/excel and print them from there? Or run a query that returns the student id and the options they have selected?
ah i should have said. that code is on a form that saves the changes to the entry, then as they select this i want the yes/no to appear and if they select yes i want to print a report for the record selected in the form.
edit: just read what you've put again and realised i misunderstood. will...
If MsgBox("Do you wish to print your choices?", vbYesNo, "Print?") = vbYes Then
********
DoCmd.Save
DoCmd.Close
Else
DoCmd.Save
DoCmd.Close
End If
This is the code I currently have, I've set up a report called options that will need...
I have a form in which students enter their student ID codes then make their choices of modules with each module being a field which they have to select using a tick box accordingly.
Once they have made their choices I want to be able to print off a report of just that one record that displays...
I am creating a form in which the user (student) has to make selections from 7 choices (each 10 or 20 credits) which must equal a total of 30 credits.
I want the save button to appear only if this criteria has been met. What is the best way of doing this?
Thanks.