I have a "Contacts" table with an autonumber field that is in a one-to-many relationship to the table "Projects". Foreign key is Contact ID (long integer). The Projects table has a field called Project Name and is set to do a lookup on a third table called Project Information. The Projects table just has boolean fields and the Project Name lookup field, plus the foreign key field. Everytime I go to select the Project Name in the subform (Project), I get the following error message, "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data (Error 3163)". The Project Name fields in both table are more than adequate, so I assume I the error message is somewhat misleading as to what the real problem is.

Why are you using DLookup on a lookup table.? Use a combo box for selecting the ID number from the Project Information table.