One to Many Form Design Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I'm fairly new to Access 2003 so I may be overlooking the obvious or I did
something wrong. I designed a One to Many Form as follows:

[1] I created a Continuous stand alone form for the parent table
[2] I created a stand alone Datasheet form for the child table

Note: both of the above are based upon queries

I then returned to the parent form, went into design mode, and added the
child table form [previously created] as a SubForm. Everything works but I
have one annoying problem. I placed the Subform just below and as close as I
possibly could to the parent form. When I open the form in a window, that's
exactly how it appears which is what I want.

However, the problem occurs when I maximize the form. Upon maximizing the
form, there is a huge gap of space between the parent table and the datasheet
view of the child table. It looks very unprofessional as there is a large
section of wasted form space that is blank.

I've tried to figure out why this is occurring but at this point in time
it's a mystery to me.

Thanks,
RT
 
Robert said:
Hello:

I'm fairly new to Access 2003 so I may be overlooking the obvious or I did
something wrong. I designed a One to Many Form as follows:

[1] I created a Continuous stand alone form for the parent table
[2] I created a stand alone Datasheet form for the child table

Note: both of the above are based upon queries

I then returned to the parent form, went into design mode, and added the
child table form [previously created] as a SubForm. Everything works but I
have one annoying problem. I placed the Subform just below and as close as I
possibly could to the parent form. When I open the form in a window, that's
exactly how it appears which is what I want.

However, the problem occurs when I maximize the form. Upon maximizing the
form, there is a huge gap of space between the parent table and the datasheet
view of the child table. It looks very unprofessional as there is a large
section of wasted form space that is blank.

I've tried to figure out why this is occurring but at this point in time
it's a mystery to me.

Thanks,
RT
Click to expand...

I'm guessing that the subform was placed in the footer of the form.
If the subform is put in the detail section of the form, rather than the
footer, that will solve the problem.

The form footer displays as a portion of the entire screen when the form
is maximized.
 
Hi Duncan:

I'll check it out because that's entirely possible. Access doesn't make it
very clear as to where the form footer is for the Main Form and the form
footer for the subform. At least it isn't clear for me.

Thanks,
RT
 
Back
Top