Run a Query

[ICTkirsten]

Hello,

i have created a button to display the current time ( sign in and out).
It works fine with this code Me.field = time$

However i need a code beneath it to run the actual query that will display this time onto the table...


im really stuck on how to go about this

any advice would be great

Thank you

i have attached an image of one of the querys i need it to run

 

[pbaldy]

You can put

Time()

in the Update To field if you want, or Now() if you need the date too.

 

[ICTkirsten]

but i need it to run one of my queries... i dont need it to display current time as my code already does that i just need the button which contains the code to also run a query that i had created

 

[pbaldy]

Since it has form references, try

DoCmd.OpenQuery

 

[ICTkirsten]

Worked perfectly! thank you very much

 

[pbaldy]

Happy to help!