On Thu, 1 Jan 2009 11:27:00 -0800, mike
wrote:

one part of the interface is bugging me. the cboSubject and cboStudent
display in column format in the subform in form view, left to right.
however, i want the cboStudent in the left column and the cboSubject in the
right column. how can i switch them?

I'd change the Default View property of the subform from Datasheet to
Continuous. You can then easily rearrange the controls in any order or
presentation you like in design view.

If you want to keep using the Datasheet view (which is IMO too inflexible for
the developer *AND* too flexible for the user, who can contract columns down
to zero and then complain that "my form doesn't display X"), open the form's
Query in design view and change the order of the columns.
--

John W. Vinson [MVP]