If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Updating Table From Form
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? |
#2
|
|||
|
|||
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, "samdert" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |
surely a form with a ListBox can be used in a query? | 1.156 | Running & Setting Up Queries | 14 | June 2nd, 2004 04:54 PM |