467,075 Members | 932 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Unbound Text Box ---> Table?

I have an unbound text box on my main form that is used to show the sum totals in my sub form. I also have a field on my main form that has a control source in a table. This bound field needs to somehow have the total form the unbound text box transferred to it. How do I go about this? I have multiple categories that can be selected through a combo box. So I am sometime just flipping through categories to see what my total is. I could just leave the total in the unbound text box that is running the function, but... I need the total in other forms. So how do I get the totals into my table form and unbound text box?
Apr 22 '09 #1
  • viewed: 1941
1 Reply
Expert 256MB
Use the double click event from the unbound text box to transfer the information between the text boxes.

Expand|Select|Wrap|Line Numbers
  1. Private Sub UnBoundTextBox_dblclick()
  2. Me.BoundTextBox = Me.UnBoundTextBox
  3. End Sub
Apr 22 '09 #2

Post your reply

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

Similar topics

2 posts views Thread by hmiller@hartford.edu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.