Main Form & Subform Continuous Movement

Question

Hi

Is it possible to have the main form and subform work like a continuous form single form so that it bocomes easier to capture data or navigate using a Tab key. Currently I have a form linked properly with the subform and working efficiently , but when I’m capturing data on the main form, the subform is hidden behind the main form , to capture data on it you have to scrow down to locate it ,though it is still fine , but I’m looking at the final user , someone may think that after capturing data on the main form  that is the end of it all since the subform is not properly visible.

Example form 1(Main Form) & form 2(Sum) are supposed to be moving together as a single form like the way the main report & sub report move, one might think that there are no links between the two because they move as a single report.

Regards

Chris

Answer 1

Thank you so much Scott , I will also just do that .

Regards

Chris

Answer 2

I always design my subforms separately using the wizard initially. I then use the subform wizard to embed the subform onto my mainform.

Answer 3

Ok

I see I will redesign the sub form and main form separately and then link the two forms using the wizard. I hope I will archieve what I want.

Thanks alot

Regards

Chris

Answer 4

 but when I’m capturing data on the main form, the subform is hidden behind the main form ,

That is impossible! A subform is embedded on the main form so there is no way for it to be hidden behind the main form. It is possible to create a form larger than the screen that would require the user to scroll down to see the subform. But that's not hidden behind the main form. 

If you have created a form that big, then I suggest you redesign it to use a Tab control. I almost never make forms that require scrolling to see different parts of the form. Instead I use a Tab control to organize my controls into logical groupings and/or embed subforms onto a Tab page. This way the user sees the tabs and knows there are more parts to the form. 

Forms and Reports are different. I'm not sure what you mean by "moving together". A subform is linked to the main form on a key field. When you change records in the main form, the record(s) in the subform change to match based on the linked field.