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
|
|||
|
|||
Another question
(I originally posted this question yesterday, but somehow it wound up
attached to an old thread from 2000 that I did not even read. How did that happen? At any rate, my question is...) Our database has two tables... one is a Directory table with the contact information for each student we work with. The student ID # is primary key. The 2nd table, linked on primary key, also includes the student's name, so our data entry people won't get confused entering records in for each student. (Form 1 is directory info; has a button taking the user to the records subform to input the specific records information for that student) Is there any way to set up the form so that the ID# and name can automatically be populated into the same fields on the 2nd table/screen? Thanks! Lisa |
#2
|
|||
|
|||
Another question
Normally, if you are talking about a subform embedded in the main form and
you have master and child relationship established, the fields should populate on their own. If your form is not linked but is actually another form that opens up, you can use default values to point to the Student id on the first form. Use your expression builder on the default line for your syntax. It would look like =Forms![frmFirstForm]![StudentID] "Lisa" wrote: (I originally posted this question yesterday, but somehow it wound up attached to an old thread from 2000 that I did not even read. How did that happen? At any rate, my question is...) Our database has two tables... one is a Directory table with the contact information for each student we work with. The student ID # is primary key. The 2nd table, linked on primary key, also includes the student's name, so our data entry people won't get confused entering records in for each student. (Form 1 is directory info; has a button taking the user to the records subform to input the specific records information for that student) Is there any way to set up the form so that the ID# and name can automatically be populated into the same fields on the 2nd table/screen? Thanks! Lisa |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Question about Absolute reference formula | Maria | General Discussion | 3 | June 23rd, 2004 06:27 PM |
Word question regarding TOC (newbie question)... | Herman Geerlings | Formatting Long Documents | 4 | June 4th, 2004 03:12 PM |
Designing a question paper | Ken | New Users | 2 | April 28th, 2004 10:13 PM |
Charting in a single cell question... | LSMark | Charts and Charting | 3 | January 8th, 2004 03:00 PM |
second question - vlookup table_array reference listed | James Dean | Worksheet Functions | 1 | December 12th, 2003 09:49 PM |