Search results

that write up really helped. I ended up doing a beforeupdate event and creating a msg box that updated the field. thx. I was just thinking in the right direction. Appreciate it.

got it, thx!

If i were to add an if statement to make sure there was something in the txtbox, in the beforeupdate, what would it be?

I've got a txt that REQUIRES something to be in it, but everytime someone edits a record i want the txtbox to blank out so they have to re-input the data. i tried putting in: Me.txtbox = "" but I get an error that says Field.txtbox. cannot be zero length string. However, if I enable...

thx all.. got it.

what would be the VB Code? sorry, i'm a complete noob

i would like the actions to take place prior to them hitting the save button since they will have to input their user ID again, this is incase it's a different user updating the record.

In my current form I have two boxes that require data to be entered. One is the user's ID number and the other is the date. The date box is currently setup so that when a new record is created is automatically puts in today's date. I would like to get it so that on modification of the current...