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

R

RacerX

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
 
J

Jody

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
 
Top