Refreshing a forms records

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I am running an Access 2000 database that has multiple
users. Each user is able to successfully enter information
in a form, however they can only see the records they
insert. I have made numerous attempts to refresh the form
data so that all the records are visible. I can do it
manually through the form filter but I am not able to set
it up to use a macro or query (it doesn't seem to want to
work) so that I can simply have the user click on a button
to perform this action.

I am not sure where I am going wrong, and I am sure it is
really simple.

thanks,
Scott
 
In the VBA code behind the command button, insert the code

Me.Requery

If using a macro then enter the Requery action [no control name]
 
Thanks for the suggestions. I am not sure why, but when I
re-created the form it did everything that it was supposed
to.

thanks,
Scott
 
If I was to put this on a cmd button that I am using to advance to the next record, how would I get it so that it still works as the requrey takes you back to record one.
 
Back
Top