Updating Forms Automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several databases that record information into 1 database. The
problem I am having is the forms are not updating without closing down and
restarting Access. I though of creating a command button that will close the
database then open it automatically. Or using a Switchboard, where they
would close the form then open it off of the Switchboard. Any other ides? I
am not sure how to create the Close/Open button.
 
Sound like you just need a command button on your form that performs a requery.


Private Sub cmdRequery_Click()
On Error GoTo ProcError

Me.Requery

ExitProc:
Exit Sub
ProcError:
MsgBox "Error " & Err.Number & ": " & Err.Description, _
vbCritical, "Error in cmdRequery_Click event procedure..."
Resume ExitProc
End Sub



Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Back
Top