M
mbr96 via AccessMonster.com
I'm getting an error message that appears when scrolling through records on a
form I built, but only certain records. This just started happening. I
can't figure out what triggers the error, i.e. what field/value causes it
(looked for patterns like null values in a field, etc.), and the error itself
doesn't make sense to me.
The error "The value you entered isn't valid for this field" fires when
moving onto certain records. But I'm not entering any data (I understand,
for example, that if I entered text into a number field that's the error I
would get). There is a relationship between the primary key of the table in
the recordsource of this form and another field in a related table, and it
has ref integrity enforced with cascade update. That's only if I change the
data, though, and I'm not.
There's no code firing on events for the form (single form, not continuous).
There's a little code on the After Update property of one control, but that
should only fire if that field is updated, right?
Not sure what else to look at. Any suggestions please?
Thanks in advance.
MBR
form I built, but only certain records. This just started happening. I
can't figure out what triggers the error, i.e. what field/value causes it
(looked for patterns like null values in a field, etc.), and the error itself
doesn't make sense to me.
The error "The value you entered isn't valid for this field" fires when
moving onto certain records. But I'm not entering any data (I understand,
for example, that if I entered text into a number field that's the error I
would get). There is a relationship between the primary key of the table in
the recordsource of this form and another field in a related table, and it
has ref integrity enforced with cascade update. That's only if I change the
data, though, and I'm not.
There's no code firing on events for the form (single form, not continuous).
There's a little code on the After Update property of one control, but that
should only fire if that field is updated, right?
Not sure what else to look at. Any suggestions please?
Thanks in advance.
MBR