View Single Post
  #16  
Old December 31st, 2008, 03:14 PM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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 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?