1-2-3-4-5....

[kentendresen]

Hi!

In my report I have a lot of questions picked out from a table. Since they are picked out, they will not be numbered in order if I use QuestionID.

I just want the numbers in front of each question to be in order, starting with 1. I guess there is a simple code I can put in my report almost like Date(), so please help me.

 

[IMO]

Create an unbound text box in the detail section of your report and type the control source as =1 and change "Running sum" to "overall".

HTH
IMO

 

[kentendresen]

Thank you so much, everything is working fine, both the numbers and the select question form. Just one more thing:

Is it possible to count how many question the user has marked? The list is quite long, so it would be nice to have a field on top of the form which counts all the marked questions.

 

[kentendresen]

And even one more thing:

When I preview the report, it always opens behind the Select Question Form. How can I move it in front? Guess it is very simple, but I couldn't find out where...

Thank you!

 

[IMO]

Create an unbound text box on your form and in the on click event of the list box put...

    Me.YourTextBox = Me.YourListBox.ItemsSelected.Count

In the click event of your print preview button...

    Me.Form.Visible = False

and in the OnClose event of the report...

     Forms!YourForm.Visible = True

HTH
IMO

 

[kentendresen]

Hi!

I still want the Select Question Form to be open, but get the Report in front of that form when I click the Print Preview button. If I set Me.Form.Visible = True, then the report opens behind the SelectQuestion form... How can I get it in front?

Thank you!

 

[Rich]

What's the point of keeping the form visible, you won't be able to see it behind the report. If you still want to do this then change the forms modal and popup properties

 

[IMO]

In the click event of your print preview button...

    Me.Form.Visible = False

and in the OnClose event of the report...

     Forms!YourForm.Visible = True

IMO