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!
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!
Attachments
Last edited: