Update unbound field

[irunergoiam]

I have a form with where two fields require data entry (one is a bound Yes/No field, the other is an unbound text field) in a form. I would like the unbound text field to update automatically with the network username when the bound field is checked by the data entry person.

I will probably need to make both fields unbound? Or if I leave it the way that it is, how do I update the network username when the unbound field is entered into or clicked on?

Finally, I need the unbound field to update back to the table. Any ideas???

Much thanks...
ad

 

[pbaldy]

I would use this:

http://www.mvps.org/access/api/api0008.htm

or the Environ() function to get the user name. You'd populate the textbox in the after update event of the other control. If you want the value saved to the table, it should be bound.

 

[DannySeager]

Why is the field unbound if you want it to update the table... why not just bind the control?