if function?

[CazB]

I tried that code out on a form I have and it worked just fine...

 

[hazell]

I think I must be putting it in the wrong place. I have the form open but it is not clicked on to any item on the form. then I clicked on the ellipsis in the ONCurrent property box and put it in the expression buider. Is this right. Sorry for being dim

 

[CazB]

I have a similar form in my training database and I actually put it on the 'before update' of the 'Score' control - that worked for me... but it should also work on the OnCurrent of the form, only thing is it will only show then when you click on the record

 

[pr2-eugin]

No okay.. so your problem is where to put the code.. See this.. http://www.baldyweb.com/FirstVBA.htm

 

[hazell]

Works perfectly now. thank you all so much