Help, My subforms on my tab control will not work.

  • Thread starter Thread starter James McKillop
  • Start date Start date
J

James McKillop

I had a problem with my subforms not going to the next
record when I Pressed the "next record" command button so
I looked into the help files. It told me to link the
MasterLinkFields and the ChildLinkFields. I did this and
it started to go to the next record, but now I can no
longer enter in anything in the data entry fields. I
click on them and nothing happens. If anyone can help
please let me know.

James
 
Most likely your MasterLinkFields and ChildLinkFields do not match. The
masterLinkField (Primary Key) from the main form must match in data,
datatype, and size to the ChildLinkFields (Foreign Key).

For example if my Main table is on Students, which contains the Primary Key,
StudentID, and I have a sub form called Classes which has a Primary Key of
ClassId and a Foreign Key of (StudentID), I must use the StudentID (Master)
from Students and link it to StudentID (Child) from Classes.

If you do not have this relationship, you won't be able to enter data. Also
if you have more than one table attached to one form, there is a good
possibility that you are preventing an update to that information.
Generally, one table to one form.
 
I found out that some of the fields can have information
put in them. but when I try to do change records it say
that "the Changes you requested to the table were not
sucessfull because they would create duplicate values in
the index, primary key or relationship." I am only
dealing in a one to one relationship that has a primary
key that is also the primary key in the main table. Any
other sugestions. Also my Child and master link are
identical.
 
I got it fixed. I had to create a new form and copy the
controls over to it. It I then inserted it in to the tab
control using the subform wizard. It then worked just
fine.

James
 
Back
Top