Updating Table From Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables, Student_Info and Reading. Student_Info is my main table.
Both tables have correlating forms.

My goal is to enter information on Student_Info form (table will update
accordingly) and then click a button where Reading form will open having some
of the same fields pre-filled with correlating fields (i.e., First_Name,
Last_Name, Student_ID) from the Student_Info form. I would then like to
enter additional information on the Reading form and then have the record
save to the Reading table.

My problem is: The forms are functioning fine. I've added a button, and
Reading opens from Student_Info with the fields that I want to display. I
can add subsequent information, but when I save the record, my reading table
only updates with the information added but the fields that I've pulled from
Student_Info doesn't write to the Reading table.

What am I doing wrong?
 
Is your Reading form using the Reading table as its record source? If it is,
and you want to be able to change student info, then use a query for your
record source (get student info for each matching entry in the reading
table). Make sure to take the foreign key as part of your record source (the
student info field from Reading). HTH,
 
Back
Top