Hi All,
Apologies for the bad explanation.
I have a some code used to test frmChemoRecord, it loops through various scenarios completing the form with a range of different values to test the output.
The problem comes when it gets to the
it throws up a OpenForm action cancelled error.
I press Debug then click Continue and it runs fine.
I've tried various things one of which is to use the button on frmChemoRecord that opens the frmDateSelect (to output the results), if I do that I get a Can't setfocus error on
. Again press Debug then click Continue and it runs fine and this time there's no error thrown up in OpenForm code. This happens during each test loop.
I can't explain why something is causing an error at this particular point in the code. Is it possible that the code running on frmChemoRecord is not completing before the testing loop is moving onto trying to output the results report. If so is there a solution?
All ideas welcome
Many Thanks
Apologies for the bad explanation.
I have a some code used to test frmChemoRecord, it loops through various scenarios completing the form with a range of different values to test the output.
The problem comes when it gets to the
Code:
DoCmd.OpenForm "frmDateSelect", acNormal, , , , acWindowNormal
I press Debug then click Continue and it runs fine.
I've tried various things one of which is to use the button on frmChemoRecord that opens the frmDateSelect (to output the results), if I do that I get a Can't setfocus error on
Code:
[Forms]![frmChemoRecord].[RuReportButton].SetFocus
I can't explain why something is causing an error at this particular point in the code. Is it possible that the code running on frmChemoRecord is not completing before the testing loop is moving onto trying to output the results report. If so is there a solution?
All ideas welcome
Many Thanks