Partner Project

[ShannonMarie]

The project that I am working on includes an IntentGrad table and a StudentGrad table. The Intent table holds info for those "intending" to graduate, while the other holds info for those who WILL graduate. The student information on the Intent form is prefilled from the student table. I need information in the term and degree field to prefill on the subform in the graduation form. I am not sure how to query the degree name when the degree code is what is stored in the Intent table? My partner is also one of two main users on this project. She said, so I'm trying to do as she said.

I apologize if this is a "simple" question to some, as a student I am still learning. Thank you for being here to help.

 

[Poot]

?!?

I am not sure how to query the degree name when the degree code is what is stored in the Intent table?

Not sure either since not enough info on your tables..

but you can take info from your intentGradTable to your grad form by setting up a subform within it with the subform control source as the intentGradTable and setting your textfields to be controlled by the relevant records.

HTH

Poot

 

[ShannonMarie]

Thanks

I changed the source from the student table to the intent table and everything filled in after testing. The subform is prefilling like it should. On to the next challenge. Again-thanks! (Too many late night studies can hinder the obvious)