471,082 Members | 944 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,082 software developers and data experts.

Code Just Stops

I have a summary form that has two columns of unbound textboxes for actual cost
and marked up price. There are eight textboxes in each column. There are also
two unbound subforms. Each set of textboxes and each subform are for something
different. I have a Calculate button that programattically fills in the
textboxes and subforms. For each set of textboxes and for each ubform there is a
query that calculates the values I need. For each I create a recordset, get the
values from the recordset and assign the values to the textboxes or subforms.
The code sequentially fills the form from top to bottom so I only need one
variable (Rst) for DAO.Recordset and one variable (QDF) for querydef. After each
pair of textboxes or after each subform, I close Rst before going to the next

The problem is that the code just stops about midway. There is no error message
or indictaion why it stops. It just fills about half to textboxes and subforms
and stops. Would this have something to do with creating so many recordsets
although I close the recordset after each calculation?


Nov 13 '05 #1
0 1142

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

109 posts views Thread by Andrew Thompson | last post: by
16 posts views Thread by graham.reeds | last post: by
5 posts views Thread by Adrian Enders | last post: by
2 posts views Thread by iwdu15 | last post: by
5 posts views Thread by Raj | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.