Viewing a subform on the same screen as a form

[ejhatch]

Hi All,

I have a macro which runs from a form. The macro just opens up a subform. The problem is that the subform gets opened up in a new window. I have changed the property to modal, but this then still opens up the subform in a dialogue box.

Basically I want to be able to view both the form (top half of the screen) and the subform (bottom half of the screen) on the same screen.

Thanks,

Evan

 

[locomotion]

place the subform as a subform in the bottom half of the screen then?

/locomotion

 

[ted.martin]

and if you want it to appear/disappear change its Visible properties

 

[ejhatch]

Hi All,

Thanks for your comments. I have decided to use the Event Procedure with some VB code - instead of the Macro, but I still have the same problem. The subform still appears as a new window. I need to subform to appear on the bottom half of the screen. Both the subform and the form need to appear as if they are one form - on the same screen. The form needs to be on top and the subform on the bottom half of the screen.

I appreciate that the 2 responses may be valid, but I probably need some more assistance. I have pasted the relevant code here:

stLinkCriteria = "[query_name]=" & "'" & Me![List6] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria, , acWindowNormal

I have changed the acWindow option to make use of all 4 options but none seem to bring up the subform in the same window as the main form.

Further help required, please.

Thanks,

Evan

 

[neileg]

The term 'subform' has a specific meaning that is not how you are using it. You are not opening a subform, you are opening another form. A subform is a form that is embedded in another form where the data in the subform is selected according to data in the form. If you open your main form in design view, and drag the 'subform' from the db window onto the main form, you will then have a true subform. There is a wizard to help in synchronising the data.