Updating a record with a value through a macro

[jlgray0127]

I have a simple form, which I am adding data into. The form's layout, represents a rack for storing material. Some locations in this rack, may contain a box that takes two locations. In this instance, I will skip the next box and then input the next part number.
I would like, when I tab outta the box I skip, a macro to paste a text phrase in the empty box.
Any thoughts on how to do this?


Thanks!

[June7]

I don't use macros, only VBA. Could try the LostFocus or Exit event of the textbox.

If IsNull(Me.textboxname) Then Me.txtboxname = "some phrase here".

If the textbox is bound, the phrase will save to table.