By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

On screen values not flowing thru to calculations properly

P: n/a
SJM
There is a database which has combo boxes to allow users to select values
from pre-set lists of common specifications. The form allows users to enter
values that are not in the dropdown lists. When all input specifications are
entered the user clicks on a button which performs a series of calculations
and returns the results. It seems when the user enters values that are not
in the drop downs the calculations come back wrong, other wise the resulting
calculations are correct. I am told that when the user steps thru the code
that when they hover the mouse over the combo box values in the vba
calculations code that they can see the correct values as entered on the
screen, yet the final result does not calculate correctly. I do not have a
copy of the database. Could this be because the values from the combo boxes
are being referenced in the code as me.CboInput1 instead of
me.CboInput1.value?
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.