Odd form issue

  • Thread starter Thread starter Tara
  • Start date Start date
T

Tara

*This error appears to only occur for one record. So far, all other records
seem unaffected.

I have a form that is used to add pregnancy screen data to a table. This
form is linked to another form, frmAssessment, via a ScreenID number. I can
add screen data just fine, but when I try add assessment data via
frmAssessment, I get an error that says 'You cannot add or change a record
because a related record is required in table 'tblScreensOLD'. There is no
tblScreensOLD, although there used to be. It was temporary table held in the
back-end of the database that I used while making some changes to the
database. I've looked everywhere and no where on ANY of the forms or in the
code, can I find a reference to this table. Like I mentioned above, it only
seems to be happening with one record. And with that record, everything in
the other tables involved is stored and retrieved perfectly. Why would this
be happening? Am I missing something?

I'm guessing my only option is to delete the record and start over, which is
no big deal, but I'm really curious as to why this is happening. Any
thoughts?

Thanks!
 
Go into your code and run debug/compile. If you have any code errors anywhere
it won't compile and will break whereever the error is.
 
Back
Top