Selecting fields on a form for inclusion in a report 2

[bxgti4x4]

I have a form which displays personal information for an employee (name, adddress, passport details, visa details etc.) The form contains 40 fields.

I would like to have a tick box alongside each field so that the user can select certain fields (e.g. passport details) and then press a command button (Create Report) which uses the selected fields to create a report.

Can anyone tell me how this can be done?

Best Regards
John

 

[KenReay]

Hi

Simplest way to do this would be (I think):

Create a report based on the same recordset as the form, but with a criteria of the prime key from the form, hide the controls (on the report) which are not checked on the form.

In the beforeformat even of the report, put code like so

If Forms!myForm!MyCheckbox = True Then
Forms!myForm!MyControl.Visible = True
Else
Forms!myForm!MyControl.Visible = False
End If

the above code needs be repeated for each control, substituting the appropraite values fro MyForm, MyCheckBoxControl, MyControl

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[bxgti4x4]

Ken,

Thanks for the idea. It may take me a while to try it out but I'll let you know.

Best regards
John

 

[bxgti4x4]

Ken,

Small problem - I have created the button on the form which will open the report but I cannot find the "beforeformat" event to which you refer. Could you please tell me where to find it.

Thanks a lot,
John

 

[KenReay]

Before Form is an event in the report object, not the button object

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[bxgti4x4]

Ken,

Sorry to be a pain but I have searched everywhere to find a reference to Before Form Event so that I can start building, but I have been able to find anything. I would appreciate some pointers on how to proceed.

Best Regards
John

 

[PHV]

Have a look at the OnFormat property of the Section object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bxgti4x4]

Ken and PHV,

Thank you both very much. Now I have the way in, I have it working well.

Best Regards
John

 

[bxgti4x4]

Ken/PHV

The code works fine and makes the appropriate controls visible or invisible. However, when it makes a control invisible you are left with a gap in the report between the visible controls either side of the invisible one.

Is there any way that this gap can be closed?

Best Regards
John

 

[KenReay]

Hi

You could move the visible controls using the .top, .left properties

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[bxgti4x4]

Ken,

Thanks for that, I'll give it a try.

Best Regards
John