Table Update

[fernin8r]

is there a way to edit text box values on a form without it editing the table?

 

[Howlsta]

When you create a text box on a form it is unbound, so you can do what you like and it won't change any fields in your tables.
Table fields are changed if you have set a field as the text boxe's control source. It sounds to me like you need to read the help more. Click on control source in the properties and press F1 this will tell you more.

 

[fernin8r]

I'm sorry...I didn't explain myself very well. I need the text box bound to a record, but i would like to use that record to create a new record, but with a different value in one of the fields "Project_number".

i want the new value to be the number that is typed into the "Project_Number" text box. I can get this done. the problem is, after i add the new record and update the form, the new value is saved to the old record. this leaves me with two records with the new "Project_Number"

Is there a way to change that form's text box without it saving to the table's record.

**I apologize if this is too confusing it's hard to explain.