subform data needs to be saved in main form's table

[R. Daniel Carlson]

I have 2 tables. One table will store student names temporalily and the
other will store several hundred company names - that are not temporary. I
have an unbound combo box in my main form which queries the company table.
When a company is selected, it's details appear in the subform. So, if I
have a company selected, and several student names typed in the main form, it
all looks perfect. Now, I want to save all of the information in the main
table (the student table) so I can do mail merge in MS Word...How would I get
that sub form information from the company table to save in the main table?
I already have fields in the main table to hold the info, I just can't seem
to get it there.

Thanks

 

[John W. Vinson]

.How would I get
that sub form information from the company table to save in the main table?
I already have fields in the main table to hold the info, I just can't seem
to get it there.

Don't.

Instead, just use a bound combo box to store the company ID in the student
table. Base the mail merge on a Query joining the student table to the company
table.

There is no benefit to storing all the company data redundantly in your
student table. That's what queries are FOR - to pull data from different
tables together!

John W. Vinson [MVP]

 

[R. Daniel Carlson]

That makes sense. Can I still manipulate that bound combo box to, when a
company record is selected, have the company information appear in either a
subform below it, or in the same form? As you say, the do not need to be
saved in the main table, but I'd still like to see a formatted version of the
record vs. just seeing the record all spread out in a combo box.
--
R. Daniel Carlson
Concordia University
Office of Development

 

[R. Daniel Carlson]

Actually, duh, I got that working too. I shouldn't have even asked.
--
R. Daniel Carlson
Concordia University
Office of Development