Discussion Locked

Access 2000 Update a List using sep Form

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to reapply a filter to a continuous forms list after adding, editing or deleting a record from a separate update form.

Is there a standard method by which to do this?

Right now I created a public variable in a module and use it as a flag to signal from the update form to the continuous forms list that a refresh to required.

I use an "On Focus" event procedure to read the flag and reapply the filter. This doesn't seem to work properly.

Am I stupid or what? Any help would be gratefully appreciated.

Many thanks, Tad Sendzimir

3 replies

by seagull data services

If I read the question right, you need to place the line below in the afterupdate event of your editing form.

forms!FormName.requery

where FormName is the name of the form containing the continuous list.
Hope this helps
John

by tadsend

John - 10^3 thanks! I knew there was a simple solution. On the other hand look what I learned about public variables in the last week!

I didn't realize that you could do an action on another form from the current forms event procedure structure.

You have helped me immensely and your intelligence is like the empire state building compared to my doll house!

Thanks, TMS

This discussion is closed to new replies.