InfoVeg

This is the strangest error I've seen that I've been able to fix on a database. If you added a level 3 plot first in a list of plots, when you go to the level 1 plot, some fields on the plot data form overlap, where the size and modules of a plot are specified.

It turns out that some SQL was executing that used a field that was in the main form currently active rather than the correct field. It was accidentally mistyped in the SQL but found a place to read from.

Incorrect SQL:
DoCmd.RunSQL "update observation set entry_plotLayoutType=IIf([cvs_Level]<3,1,3) where entry_plotLayoutType is null;"

correct SQL:
DoCmd.RunSQL "update observation set entry_plotLayoutType=IIf([cust_cvs_samplingLevel]<3,1,3) where entry_plotLayoutType is null;"