sub form issues

[wmrainer]

Our database is being used a registration system. It was built over 20 years ago and we've moved to 2013 now, but it's having some issues.
Our subform is attached. We think it's getting hung up on some of the expression. I've checked them and they all seem okay, but they are the only things that all of the macros, forms, etc. have in common.

Code field: =IIf((([QUAN]+[NUMBER])>[CAPACITY]),0,1)

Number: =DSum("[TKTS]","REGIS_DETAIL"," [EVENT ID]=FORM.[EVENT ID]")

It's getting up right as you enter the Quan field. For instance, if someone else gets into the data, it's like it's getting interrupted then everything just halts which cause all of the macros later on in the subform to freak.

Any help is greatly appreciated!

 

[vbaInet]

It's getting up right as you enter the Quan field. For instance, if someone else gets into the data, it's like it's getting interrupted then everything just halts which cause all of the macros later on in the subform to freak.

I'm sure all this is making sense to you but to me it isn't unfortunately. I can't see your database so without a more descriptive problem/scenario, I won't be able able to give any constructive advice.

 

[RuralGuy]

Have you considered the fact that "Number" is a reserved word?
http://www.allenbrowne.com/AppIssueBadWord.html#N