REFRESH A FORM/TABLE MADE BY A QUERY WHICH IS OPENED

G

Guest

Help Me.
I need to auto refresh a Form from a TABLE (I'm doing this now in the
[event] with a timer), but the table also needs to be auto refreshing which
is a make table using a MTQuery.
What I'm I doing wrong?
Racer X
 
G

Guest

What are you using the form for?

If you just want a new record each time it's opened ; open the form in
design view, go to the form properties, click on the data tab set the data
entry to yes. Or on the events tab select the "on Open" event and put the
following code in:
docmd.GoToRecord,,AccNewRecord
 

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