M
Mike Thomas
In Access 2000 we have a form with the buttons for moving to the next
record, previous record, etc. The standard DoCmd.GoToRecord , ,
acPrevious, acNext etc.
We check the data before we move. We have a situation where, if there is a
problem with the data, we want to show a report in preview mode, then they
can print it, but still allow the user to move off of the record. The
screen should display this new record when they close the report window.
If needed, the report is called as follows - DoCmd.OpenReport
"PackedPicked3", acViewPreview
Then, the DoCmd.GoToRecord , , acPrevious, etc command is issued.
If the user tried to go the prev record, the screen simply shows the same
record they had been on before the report opened.
If they tried to go to the next record, they get an error "You cannot use
the GoTo Record action on an object in Design View".
Does anyone know what the fix for this problem is?
Many thanks
Mike Thomas
record, previous record, etc. The standard DoCmd.GoToRecord , ,
acPrevious, acNext etc.
We check the data before we move. We have a situation where, if there is a
problem with the data, we want to show a report in preview mode, then they
can print it, but still allow the user to move off of the record. The
screen should display this new record when they close the report window.
If needed, the report is called as follows - DoCmd.OpenReport
"PackedPicked3", acViewPreview
Then, the DoCmd.GoToRecord , , acPrevious, etc command is issued.
If the user tried to go the prev record, the screen simply shows the same
record they had been on before the report opened.
If they tried to go to the next record, they get an error "You cannot use
the GoTo Record action on an object in Design View".
Does anyone know what the fix for this problem is?
Many thanks
Mike Thomas