Quick question regarding unbound textbox in forms

[isapple]

Hi,

I was just wondering if there is any way to transfer the data in an unbound textbox into a separate table.

User enters an amount into a textbox2, and then it does some calculations that involves textbox1 and textbox2. Finally, textbox3 has the final answer. Can textbox3 overwrite textbox1's data on the table and on the form?

Also, is there an "auto date" feature in tables? If new data is put into tables, Today's date appears on the date column?

Thank you.

 

[KenHigg]

me.textbox1 = me.textbox2

Need to makesure you did into some kind of circular reference. Or better yet why not leave it alone and calculate on the fly whenever you need to. This would make sure the data becomes 'out of sync'.

??

 

[isapple]

Okay, can you tell me anything about unbound textboxes being written into tables?

 

[KenHigg]

Have you ever written code in Access?

 

[isapple]

I've been trying but nothing seems to work

 

[KenHigg]

Open a form in design view and put a button on it the open the vba code window for the buttons click event