How do I reset the value of a field in a query after it is run

[nancylynn]

How do I reset the value of a field? I am using TransferText and after it exports, I want the value of a field to be reset (yes/no). I need it to go back to no for all records.

 

[jgoodman00]

How many of these controls do you have on your form?

If it is a lot, then you could cycle through the controls collection, & assuming you have named the controls logically you should be able to reset them based upon a few rules.

If there are only a few controls then you could manually reset each control... James Goodman

 

[TrojanRabbit]

You might be able to say, in query design, <field name>: 'No' or, in SQL design, 'No' AS <field name>. Haven't done this with strings, so I don't know for sure if it works.

 

[nancylynn]

HI James,
Thanks for the help. How do I manually reset each control??? I only have one and it's called &quot;Modified&quot;. Please help.

 

[scking]

You must obviously click a command button to invoke TransferText. In the command button Click event merely:

Me.Modified = Null

Or even set some criteria for it to null to. If the TransferText is successful then set it to null.

Steve King Growth follows a healthy professional curiosity

 

[nancylynn]

Now I get nothing when I export. I want it to export all of the fields of the modified record in the table. I have this for the On Click of &quot;modified&quot; field:

Private Sub Modified_Click()
Me.Modified = &quot;Null&quot;
End Sub

Now nothing exports. Thanks so much for taking the time to help.

 

[jgoodman00]

You are missing the export code.
All that will happen with the code you have posted is it will reset the Modified field to null.
You are also setting it to a string called 'null', rather than assigning it null. You need to remove the inverted commas to assign null to the field... James Goodman