Controlling when a record is written

[mustaphapint]

Hello. I'm fairly new to Access and I would appreciate knowing how to do the following.
I have a form which displays some product details and a stock level. The subform below it allows entry of a quantity to issue and a control button to run a small macro, write a movement record to a stock movement table and then close the form. This works fine.
But the user can also cause the movement record to be written just by keying in a quantity and tabbing out. If this is done several times it writes several movement records and doesn't close the form. I want to ensure that record is only written when the command button is pressed.
Perhaps there is a more conventional or better way of achieving what I want but I can't think of it.

 

[spikepl]

Play with the form's Property Sheet-> Other (tab) -> Cycle (property)

 

[mustaphapint]

Thank you Spike. Exactly what I wanted