Form requery is refusing to cooperate! Help

[speakers_86]

just as breaking the habit for lookup fields... god i've found that really difficult.

I think it is disappointing, to say the least, that I was taught to use lookup fields in an IT class I took a while back. Why would they do that?

 

[dfenton]

would it be possible for me to only ever use the bang, and never a period? or are there instances where i MUST use a period?

For control references, there is no case where you *must* use the dot.

i agree with speakers - it will be a hard habit to break, expecially seeing as, in the VBA editor, if i type "Me.", then access brings up a list of things i can put in after the period, such as a control name.... if i type in "Me!", it doesn't - i would have to remember how i've named/spelt my control AND whether i'm even thinking of the correct form/control...

You can get Intellisense with Ctrl-Space with Me! -- it's not the same Intellisense list as you get with Me. but once you type a character or two, it's the same list.