text box and using me.dirty = false

[DanielR]

My form has a text box which has a control source pointing to a different form. When I use me.dirty = false and it automatically writes to my table, the text box value does not get recorded because of the control source.

How can I ensure that the text box value gets inserted into the table?

 

[Minty]

It's an unbound control - how would you expect it save the value and where to ?

 

[arnelgp]

Add another textbox bound it to the field on the table you want to save. Make this textbox visible oroperty to No so it is not seen.

Before issuing Me.dirty=false, transfer the content of the unbound textbox to the new hidden tbox:

Me.boundtexboxname=me.unboundtextboxname
Me.dirty=false

 

[DanielR]

Good solutions...Thank you.

 

[arnelgp]

Welcome and be sure to test it