Mike,

Good to know 'cause it's almost midnight here and I need my rest )

Go into design mode of the form (the little blue triangle and move the
fields around/over/up/down...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

"mike" wrote in message
...
Gina,

thx to you more progress

i ended up putting cboStudent in the subform. when i select a student and
subject, it creates a new record in tblStudentSubject correctly.

interface issue: the cboStudent and cboSubject show up in column format
on
the subform. is there a way to format to make it more aesthetically
pleasing
i.e. some separation between the two cbo's?

"Gina Whipp" wrote:

Okay, well that explains it... Unfortunately, Access does have a bit of
a
'learning curve' that isn't obvious right out of the box. You have few
more
days until break is over... you should make it!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
"mike" wrote in message
...
i'm a hs teacher who took on a project over break (not paid). trying
to
use
access to streamline teacher recommendation process at our school.
right
now
each teacher has to fill out a paper form for each student to select
which
subjects he/she recommends for the coming year. then guidance has to
gather
all the paper forms and figure out which student was recommended for
which
class(es), all this in a short turnaround timeframe.

needless to say its not very efficient so i volunteered to try and
create
a
program to do this so. interface to show list of students and
subjects,
allow teacher to select student and subject, then run reports for
guidance.

its turning out to be a bigger task than i thought (always is but i'm
getting close

"Gina Whipp" wrote:

Oops forgot about that...

You can't use the wizard to link them... Go to Properties of the
Subform

LinkChildField = NameOfStudentIDField in tblStudentSubjects
LinkMasterFields = NameOfComboBox on Main form

Student ID is blank because the form is not linked AND you need to
create
a
Relationship between the tables with Cascading Updates set to Yes...

You know I'm starting to get the impression I am doing your classwork
for
you. Is this an assignment?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
"mike" wrote in message
...
Gina,

1. - 3. The combo box on the Main Form should be unbound. You do
not
need
to save the value for anything.
got it.

4. Subform should be in continuous view and attached to the Main
Form
(Link
Fields) StudentID. Then the field Student Subject should be a
combo
box
using the tblSubjects as the Record Source and the value should be
bound
to
the ssStudentSubject.
-how do i (or when in the wizard do i) link the subform to the main
form?
-tried setting "Source object" for subform to main form but when i
try
to
link child/master fields, get message stating "cant link unbound
forms"

tried all above 1)new record is created in tblStudentSubject w/
correct
subject from cbo in subform but 2)studentID is blank.