Combo Box hell or why do I get and error when I do this?

[DawnTreader]

Hello All

I have a few situations where i am trying to get a combo box to do soemthing
and it keeps giving me errors or not doing what i want.

in the first instance i am using this code:

Private Sub cboChangeRep_BeforeUpdate(Cancel As Integer)
If MsgBox("Are you sure?", vbYesNo, "Change Service Representative?") =
vbYes Then
Me.ISServiceRepID = Me.cboChangeRep
Else
MsgBox "Change Aborted", vbOKOnly, "Aborted"
Cancel = True
Me.cboChangeRep = ""
End If
End Sub

why do i get an error saying:
runtime error -2147352567

the macro or function set to the beforeupdate or validationrule property for
htis field is preventing database from saving the data in the field.

i have some similar other instances, but i want to get this fixed asap. will
post the others when i have this out of the way.

 

[DawnTreader]

Hello Dirk

Thanks! this is great.

for some reason i cant find some of my most recent posts after posting. i
have been able to search by my user name and always find what i have been
looking for before. now it seems that my posts are not able to be found by my
user name. that is why i have posted this twice and another recent post 4
times. it makes me a little angry because i dont know what has changed. at
least i know now that i can find everything i post and get notifications on
from my profile page. i dont like looking stupid and posting as many times as
i have for this and the other topic makes me look like a loon.

live and learn...

 

[Dirk Goldgar]

Thanks! this is great.

You're welcome.\

for some reason i cant find some of my most recent posts after posting. i
have been able to search by my user name and always find what i have been
looking for before. now it seems that my posts are not able to be found by
my
user name. that is why i have posted this twice and another recent post 4
times. it makes me a little angry because i dont know what has changed. at
least i know now that i can find everything i post and get notifications
on
from my profile page. i dont like looking stupid and posting as many times
as
i have for this and the other topic makes me look like a loon.

Don't worry, you're not the only one. The folks at Microsoft have been
having some server troubles lately, and that's probably why you've been
having trouble finding your posts. I trust that eventually they'll have
things back to normal again.