code to requery automatically

I

indigo

hi..

i'd be grateful if someone could tell me the syntax of how to have a form
requery on a set timescale.

currently have a macro called requery.
strangely this macro seems to keep disapearing. get messsage that " this
action or command isn't avialable now" but i can see the macro in the
listing. using access 2003 in 2000 file format.

have
Sub Form_Load()
Me.TimerInterval = 1000
End Sub

me.requery = timerinterval

end sub

i'm assuming i've missed a whole pile of stuff out here
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top