new record in subform

  • Thread starter Thread starter Mary Beth
  • Start date Start date
M

Mary Beth

Hi -

I have a main form (frmConsumer) and subform (sfrmProgram). I am
experiencing a problem when 1) there is a parent record but no child record,
the subform greys out (you can still see the form outline). In order to fix
this problem, I put the fkConsumerID on the subform to "force" a record -
the subform is no longer greyed out. However, 2) I now cannot create a new
record on the subform because I get the message about duplicates. I changed
the fkConsumerID index to "No", but I still cannot create the new record. I
have navigation buttons on the subform.

Thanks for the assistance.
Mary Beth
 
A co-worker helped me fix this problem. I did not change my relationship
from one-to-one to one-to-many after I removed the index on the fkConsumerID.
Thanks anyway.
 
Back
Top