Re: purpose of subform?

Mike,

Like a rock!!!

1. Are you using Access 2007? Maybe you said but I missed that. In
earlier versions to get to design mode you clicked a blue triangle looking
button. If Access 2007, then you probably have to UNgroup them to get them
to move independently of each other. I THINK this can be done by
right-clicking on one of the boxes and select 'ungroup'. If that doesn't
work I'll have to open my Access 2007 and have a look. Also, if you are
using Data*** View then they will always be side-by-side no matter where
you move them.

2. Then by all means add the button to add a new record. You know your
users better then anyone.

--
Gina Whipp

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

"mike" <mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:36402916-9186-42ED-AB7B-F879B7BE9EB0@xxxxxxxxxxxxxxxx
Gina,

hope you slept well:)

Go into design mode of the form (the little blue triangle and move the
fields around/over/up/down...
-when i go into design mode, the cbo's show up as independent boxes inside
the subform which i can move all around (no blue triangles?) but no matter
they still show up as side-by-side columns in form view.

-also i think there will be less incorrect entries if i add a cmdBtn to
allow user(teacher) to confirm selection. else, as soon as a class is
selected its written to tblStudentSubject which i believe will lead to
alot
of invalid entries. is that difficult to change?


.