M
mcxg46
Hi,
I have recently converted a database from access 95 to 2000, and several
macros no longer work.
The main one is used in the following way (others in a similar manner):
I have a form containing several subforms that allow account details for
customers to be entered, and a further subform showing the chosen customer's
account balance. When the information has been entered via a subform, a
button is clicked which runs a macro to update the balance. The macro only
has two lines - a gotocontrol (the argument specifying the subform showing
the balance), then a requery. The requery used to be without an argument, but
in 2000 there is the option to specify the control to be requeried.
However, whilst this used to work, now when the query is run (either with
the subform specified in the argument, or left blank) I get the error
message: "You can't use the applyfilter action on this window".
Can anyone tell me what I am doing wrong?
Thanks,
John
I have recently converted a database from access 95 to 2000, and several
macros no longer work.
The main one is used in the following way (others in a similar manner):
I have a form containing several subforms that allow account details for
customers to be entered, and a further subform showing the chosen customer's
account balance. When the information has been entered via a subform, a
button is clicked which runs a macro to update the balance. The macro only
has two lines - a gotocontrol (the argument specifying the subform showing
the balance), then a requery. The requery used to be without an argument, but
in 2000 there is the option to specify the control to be requeried.
However, whilst this used to work, now when the query is run (either with
the subform specified in the argument, or left blank) I get the error
message: "You can't use the applyfilter action on this window".
Can anyone tell me what I am doing wrong?
Thanks,
John