468,539 Members | 1,769 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,539 developers. It's quick & easy.

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
calculation.

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?

Thanks!

Traci
Nov 13 '05 #1
0 1071

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
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.