H
Hank@ieudev
Anyone. This should be easy but the closing of the form seems to be an art.
Someone got way too complicated from the looks of it.
I have a form which exceeds the limitations of Access 2000 in the open
statement. As a result I have to open another form to execute a query to
accumulate a total field. I can open the additional form and get the
accumulated total visa vi the query on a field in the hidden form but the
form will not let me close it once the query has completed and populated the
form field. This is not a sub form. It is just a form which I open via a
selective DoCmd.OpenForm from a module initiated from an embedded subform in
another form. When I try to close the form with the accumulation field and
return the value of the accumulation field I get the error 2585 indicating
the form is still being processed. I've tried resetting the focus to another
dummy field on that form first as well as using the goto.control command with
no luck. I don't want the user to even see the accumulation form (query
form) but I have to do it this way due to SQL/Query Language length
limitations. Any help would be GREATLY appreciated.
Hank
Someone got way too complicated from the looks of it.
I have a form which exceeds the limitations of Access 2000 in the open
statement. As a result I have to open another form to execute a query to
accumulate a total field. I can open the additional form and get the
accumulated total visa vi the query on a field in the hidden form but the
form will not let me close it once the query has completed and populated the
form field. This is not a sub form. It is just a form which I open via a
selective DoCmd.OpenForm from a module initiated from an embedded subform in
another form. When I try to close the form with the accumulation field and
return the value of the accumulation field I get the error 2585 indicating
the form is still being processed. I've tried resetting the focus to another
dummy field on that form first as well as using the goto.control command with
no luck. I don't want the user to even see the accumulation form (query
form) but I have to do it this way due to SQL/Query Language length
limitations. Any help would be GREATLY appreciated.
Hank