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 Datasheet 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" wrote in message
...
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?