I am using Access 2002 and have two tables (Main and Actions) linked
(in Relationships) on one field "CAL_ID" (primary key in Main Table).
Main Table is a list of equipment. Actions Table lists actions
performed on these pieces of equipment (calibration, cleaning, etc.) so
there are many records per every one record in the Main Table.
I have a form based on Main Table, containing a subform for Actions
Table. This is used for data entry: to add new pieces of equipment,
and new actions. The subform is linked master and child on the CAL_ID
field present in both tables.
Here is my problem: Whenever I go over to the subform and start
entering data in any field (date, combo box, memo field, etc.) I get
the message "The value you entered isn't valid for this field." As
soon as I hit the OK button, it allows me to enter data as normal. I
do NOT get this error when the subform is not linked master and child,
however then I don't get the corresponding Action records as I cycle
through the Main Table records. I also get the error if I have the
subform on Datasheet View. Does anyone know what is wrong? I don't
know if it matters, but the combo box has a Value List, and the Date
field had a Short Date format assigned (because I get this error
regardless of the field, I wouldn't think this affects it).
Liana