Form locks up when subform gets focus...

  • Thread starter Thread starter Fletcher
  • Start date Start date
F

Fletcher

Hi, I'm having a problem where when I go to a subform that has a
default view of continuous forms, it locks up the main form and other
sub forms and will not go to the next record either. It will only
allow changes to the first entry...can anyone help?

Thanks,

Fletcher....
 
There is most likely a relationship problem between the main form's record
source and the subform's record source. If the primary key in the main
table is MainID, there needs to be a corresponding field (foreign key) in
the subform's table. The foreign key needs to be the same data type as the
PK (e.g. number, text), except that if the PK is autonumber the FK needs to
be long integer. The FK cannot be autonumber. It makes it simpler if the
FK has the same name as the PK, but it's not required. Open the
relationships window and establish a relationship between the PK and the FK.
Click Enforce Referential Integrity.
If this does not address the question you will need to provide more
information about how this is structured.
 
Back
Top