Requery Problem

[Guest]

Access 2002. I have a subform with 4 fields linked to a 1 record table. A
command button is on the subform that executes a macro that deletes the
record in the table, populates it with a new record, and performs a requery.
This process works flawlessly on my computer where I created it, but when I
execute this process at other computers I get a halt at the requery stage and
if I halt or close that box I get another message that says "You can't use
the ApplyFilter action on this window". Can anyone make sense of this for me
and tell me how to correct it? Thanks, Rob Wilson

 

[Wayne Morgan]

If it works on one computer, but not another, it is usually one of the
following:

1) Office, Jet, and/or MDAC service packs are the same on all computers. You
can get the newest ones here.

Office: http://update.microsoft.com or
http://office.microsoft.com/en-us/officeupdate/default.aspx and click on
"Check for updates"

Jet/MDAC: http://msdn.microsoft.com/data/downloads/updates/default.aspx

2) A References problem. For more information, see this link:
http://www.allenbrowne.com/ser-38.html