macro

[Baggers]

Does anyone know how to click a button in a form using a macro, i want the macro to run the filter button I've set up but cant find the section in the macro that would allow me to do this?

[Hack]

Take the code in the button's click event and make it into a Sub routine and have the macro run the Sub.

[tarius222000]

when viewing the form in edit mode, double click on the command button. you should get where you can insert code. the subroutine should be title as such.

Private Sub CommandButton1_Click()

if you don't see the click then you did it wrong.

if you are then trying to use another button in the same form to run the click event, then just type it out as

Call CommandButton1_Click()

[Baggers]

thats brilliant thanks again for your help guys, thumbs up to your eclectic knowledge on a database front!