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

Form Calculations

P: 1
Hi i'm any body that can help. Iv'e a problem with a form were a text box field value is calculated from 2 dropdown boxes. The text box shows the calculated value but i cant get to insert the table. If you can help let us now


[email removed]
Jun 3 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 159
I'm guessing but It sounds like youv'e set the control source of your text box to the the formula based on the values of the two combo boxes (something like "= combo1 * combo2"). Putting a formula in the textboxes control source causes it to become unbound, meaning it is not directly associated with a field in the forms record source.
The simplest way to correct your problem would be to set the textboxes control source back to the table field you want to save it's data to and use the after update events of the comboboxes to change the value in the textbox.

Expand|Select|Wrap|Line Numbers
  1. private sub combo1_afterupdate()
  2. me.text3 = combo1*combo2
  3. end sub
  5. private sub combo2_afterupdate()
  6. combo1_afterupdate
  7. End sub
I don't know what formula your using or the names of your controls so this is just a vague example.
Jun 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.