L
Leslie Isaacs
Hello All
This problem relates to one I posted last week and which Steve Schapel
helped me with. Although I was then able to get my macros running OK, I am
now trying to use the same principle for another use and am coming up
against similar problems.
The problems comes from a macro with which I am tring to do 2 things - go to
the next record on the current form (which is open in continuous-form view),
and increment by 1 the value of a textbox in the form footer. I have found
that if the macro just starts with the GoTo>Next action, this part works OK,
but if the macro starts with anything else - e.g. a MsgBox action, I get a
message that I can't go to the specified record. Assuming this to be because
the focus has left the form I put a SelectObject action immediately before
the GoTo>Next action, but then I get a message that I can't use the
GoToRecord action in an object that is in design view.
There is a seperate (presumably unrelated) problem with the SetValue action.
With no other actions in the macro, I get a Type Mismatch error, even though
the textbox is formatted as General Number. The item argument is
[Forms]![frm search cat 1]![ReportsSent] and the expression argument is
[Forms]![frm search cat 1]![ReportsSent] + 1
I should add the the macro is being 'fired' as the OnClick event of a button
in the form's footer - right next to the textbox whose value I am trying to
increment.
I hope someone can help with this (Steve Schapel - are you there?) as it's
driving me nuts!
Many thanks
Leslie Isaacs
This problem relates to one I posted last week and which Steve Schapel
helped me with. Although I was then able to get my macros running OK, I am
now trying to use the same principle for another use and am coming up
against similar problems.
The problems comes from a macro with which I am tring to do 2 things - go to
the next record on the current form (which is open in continuous-form view),
and increment by 1 the value of a textbox in the form footer. I have found
that if the macro just starts with the GoTo>Next action, this part works OK,
but if the macro starts with anything else - e.g. a MsgBox action, I get a
message that I can't go to the specified record. Assuming this to be because
the focus has left the form I put a SelectObject action immediately before
the GoTo>Next action, but then I get a message that I can't use the
GoToRecord action in an object that is in design view.
There is a seperate (presumably unrelated) problem with the SetValue action.
With no other actions in the macro, I get a Type Mismatch error, even though
the textbox is formatted as General Number. The item argument is
[Forms]![frm search cat 1]![ReportsSent] and the expression argument is
[Forms]![frm search cat 1]![ReportsSent] + 1
I should add the the macro is being 'fired' as the OnClick event of a button
in the form's footer - right next to the textbox whose value I am trying to
increment.
I hope someone can help with this (Steve Schapel - are you there?) as it's
driving me nuts!
Many thanks
Leslie Isaacs