Front end of a database

[mtrimpin24]

I'm having trouble getting a database to update. its split into a front and
back end. When data is entered in the table on the back end though, it never
updates on the front end until the database is closed and reopened. even
when i query the table again by attaching it to the "before update" on the
search button, it doesn't show up by the next search.

 

[Dennis]

The other guys might have a different response, but when I want to force the
posting up DB updates, I use DBEngine RefreshCache (don't remember the exact
syntax; haven't coded that bit in over a year.) Look it up in Access HELP and
you'll be on your way...