J
JHB
Hi:
In an Access Macro, I am attempting to set a conditional situation to
detect the end of a table. In the conditional column, i have created
the following statement:
IsError(Command[Records GoToNext])
The intent is that the action which follows will be executed IF an
error would be detected by attempting to move to the next record,
since you are at the end of the table. Sadly, there is an error in the
syntax (and possibly the logic) which makes it unaccptable to Access.
I am hoping that some kind soul will point out the error, and give me
the correct statement in a form that will work.
Thanks in advance
John Baker
In an Access Macro, I am attempting to set a conditional situation to
detect the end of a table. In the conditional column, i have created
the following statement:
IsError(Command[Records GoToNext])
The intent is that the action which follows will be executed IF an
error would be detected by attempting to move to the next record,
since you are at the end of the table. Sadly, there is an error in the
syntax (and possibly the logic) which makes it unaccptable to Access.
I am hoping that some kind soul will point out the error, and give me
the correct statement in a form that will work.
Thanks in advance
John Baker