access mous question 2

[harleynana]

on the mous test requirements, one question is "how to insert a subform, without using the wizard" the office assistant only gives help with using the wizard......any ideas.... thanks

 

[Brogrim]

Place a subform on the form using the subform button on the Toolbox toolbar.

1. Right Click on the Subform and click properties
2. Select the form you want to use from the Sourse Object
3. Click on "link Child Fields" and the the 3 dots to the right hand side
4. The "Subform Field Linker" opens
5. SElect the field from the Child Fields:
6. Select the corresponding field from the Master Fields:

This is the link between the forms

Master represents the Form
Child represents the Subform.

Hope this helps

 

[danvlas]

Or...

Have your main form open in Design View.

Go to Window-Tile Vertically
From the Database window, drag the appropriate form onto the 'main form'

Good old Access 2.0

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Brogrim]

Thanx Daniel

Much more straight forward

Alan