Forms and Browse

Hi Paul,

Thank you for your question.

There is no answer in the front end of Access but you need to create some Access VBA code. The link below contains the vba code needed.

http://www.access-programmers.co.uk/forums/showthread.php?t=120524

On the form, switch to Design View and create a command button. Now select the button and go to properties. Select the Data Tab and click on the 3 dots at the end.

Copy the code from the link and paste it between the Private Sub and End Sub.

I hope this helps.

Regards

Simon