MS Access subform problems

  • Thread starter Thread starter smiffy
  • Start date Start date
S

smiffy

Guest
Have a problem with a database which ran fine under Access 97, but opening it under Access 2002 presents a problem with a subform.
The main form will not open until a "enter parameter" value is entered for 4 values.
The Parent-child link between the two forms (main and sub) is the primary key field.


The db is a membership database which has two main tables, one for family details, and the other (on which the subform is based) having the individual member details of the family members. The logic is that th "one" relationship is the "Family" table and the "Many" side is the table with family members.

Any clues why the two versions of Access don't open the db the same?
Help
 
Is your subform based on a query that is getting values from your form?
 
Subform is based on one of the two underlying tables, not on a query at all.
 
Subform not linking

I dont seem able to get my subform and main form working together. the child parent links both point to specId and when i enter data in the forms both tables are updated - but... the specId isnt posted.
specId is primary key of the table that the subform is based on, and present in the table that the other form is based on.
there is a relationship between both forms (though i cant enforce referential integrity)
 

Users who are viewing this thread

Back
Top Bottom