new record in subform

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
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First Subform record gets modified when closing form 3
subform entry makes new form record 4
Unremovable horizontal scroll bar on subform 1
New Record Disabled in Subform 1
Trouble associating parent form record to subform's record 1
VBA Syntax for subform record source change 6
Saving a record in subform 5
New Parent Record from Navigation Buttons 2

Top