error when moving through recs on form

  • Thread starter mbr96 via AccessMonster.com
  • Start date
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
 
M

mbr96 via AccessMonster.com

i started deleting controls until i found the culprit - i had combo box still
built on an old design, any new records being coded using that combo box
caused problem.

Thanks for listening - got it fixed.
MBR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top