how can i make the beforeUpdate event trigger even if no data was changed on the form?
i've tried this in the on_current
dim temp as string
temp = me.firstName
me.firstName = ""
me.firstName = temp
this works for a little bit but then I get a error
run-time error '-2147352567(80020009)':
The data has been changed.
I need to do this bc I'm parsing a phone number into separate fields for the interface, if the user changes on the phone number and goes to another record, the beforeUpdate event does not trigger
thanks "so many events, so little time"
i've tried this in the on_current
dim temp as string
temp = me.firstName
me.firstName = ""
me.firstName = temp
this works for a little bit but then I get a error
run-time error '-2147352567(80020009)':
The data has been changed.
I need to do this bc I'm parsing a phone number into separate fields for the interface, if the user changes on the phone number and goes to another record, the beforeUpdate event does not trigger
thanks "so many events, so little time"