General discussion

Locked

Access 2000 Update a List using sep Form

By TadSend ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2000 Update a List using sep Form

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

Collapse -

Access 2000 Update a List using sep Form

by TadSend In reply to Access 2000 Update a List ...

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

Collapse -

Access 2000 Update a List using sep Form

by TadSend In reply to Access 2000 Update a List ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums