Command Button press multiple times

[Symon]

I would recommend you change your textbox name from Amount to txtAmount for two reasons. If you use a real word like "Amount" it could turn out to be a reserved word, one used by MS Access itself and this could cause you no end of problems. By adding the prefix you totally eliminate this possibility. Do the same for all of your controls, you can use one of the recommended naming schemes or you can use your own scheme.

The second reason is when you are reading through your VBA code you immediately know the nature of the control and it can help you spot problems quickly and easily.

Will do,

I do normally use this method, just being quite impatient with this today.. :banghead:

thanks again...

 

[Uncle Gizmo]

Ah! I been there and understand! It's not necessary, but the benefits are tremendous especially when your db gets big and complicated.