Control Source

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I need help

I have a control source with a calculated value. I need this value to appear
in a table inorder for me to perform a query. How can I get acces to copy
calculated information into table?


I was told to use afterupdate. But I have no idea how to utilize VB. Can
someone give me an example if this is the correct step to take
 
Greg said:
I need help

I have a control source with a calculated value. I need this value to appear
in a table inorder for me to perform a query. How can I get acces to copy
calculated information into table?


I was told to use afterupdate. But I have no idea how to utilize VB. Can
someone give me an example if this is the correct step to take
Click to expand...

Just put the calculation in the query. Calculation results should (almost)
never be stored.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Control on subform / combo box requesting parameter 0
Make one final list from four sources 1
Access Create option group without using wizard? 2
Multi-step query/automation problem 2
Query and List Box 1
store a calculated value 17
Count text values in a Access Field 0
vba code help for multiple string searching 0

Back
Top