E
ExcelMan
I have a form with several controls including a single subform. The
form is designed to allow data entry for a table with a six part key.
The first several controls - a combo box and two list boxes -- allow
the user to determine the first five parts of the key.
The entries into the subform, presented in datasheet view, include the
last element of the key and a couple of attributes.
The problem is that when the user attempts to enter the key value that
goes into the subform, the system pops up error messages the first two
times an attempt is made. On the third attempt the data will be
accepted. Usually the error message indicates that the value in the
key violates a validation rule I have for that field. But this occurs
before the entire value has even been entered in the field (the user
has not hit ENTER or moved from the field by mouse). When I remove the
validation rule entirely, I get other error messages such as duplicate
key values, etc. So I don't think the problem is actually the
validation rule, but something deeper. Again, the funny thing is that
after clicking away the error message twice, the system lets the user
enter the data the third time and then seems to store it properly in
the table.
Any ideas on what might be causing this would be welcomed. In
particular, I heard there is a rule about nesting subforms more than 3
layers deep. I think I've gone around this problem by only having a
single subform. But it does have 5 values from the main form it uses
in the Master/Child link properties of the subform. Is that ok or is
the problem somewhere else?
Thanks.
form is designed to allow data entry for a table with a six part key.
The first several controls - a combo box and two list boxes -- allow
the user to determine the first five parts of the key.
The entries into the subform, presented in datasheet view, include the
last element of the key and a couple of attributes.
The problem is that when the user attempts to enter the key value that
goes into the subform, the system pops up error messages the first two
times an attempt is made. On the third attempt the data will be
accepted. Usually the error message indicates that the value in the
key violates a validation rule I have for that field. But this occurs
before the entire value has even been entered in the field (the user
has not hit ENTER or moved from the field by mouse). When I remove the
validation rule entirely, I get other error messages such as duplicate
key values, etc. So I don't think the problem is actually the
validation rule, but something deeper. Again, the funny thing is that
after clicking away the error message twice, the system lets the user
enter the data the third time and then seems to store it properly in
the table.
Any ideas on what might be causing this would be welcomed. In
particular, I heard there is a rule about nesting subforms more than 3
layers deep. I think I've gone around this problem by only having a
single subform. But it does have 5 values from the main form it uses
in the Master/Child link properties of the subform. Is that ok or is
the problem somewhere else?
Thanks.