Clear field on form

[Raven]

I have a combo box on a form.... which you can make a selection from a drop down list and print the selected report.

I would like this field to be cleared once the print has been taken.

I have tried me.[fieldname]=Null but I'm not sure exactly where to place this code - or if this code is correct.

Your help would be appreciated.

Thanks.

 

[dcx693]

The code should work, assuming your combo box is called "fieldname". You need to place that code in an event that gets triggered when you print the report. How do you send the report to print? Using a command button?

 

[Raven]

Yes it's sent via a commond button.

 

[Raven]

Thanks for the prompt, your hints led me to place the code on the print command button which worked!