How to code subform?

[Min]

Hi, What I want to do is when user click a cell on a table such as client's
name, then a sub form will load display all invoice of the client. I am not
familiar with subform. I would be great appreciated if anyone can give a
step by step instruction.
Min

 

[Mike Painter]

Hi, What I want to do is when user click a cell on a table such as
client's name, then a sub form will load display all invoice of the
client. I am not familiar with subform. I would be great appreciated
if anyone can give a step by step instruction.
Min

There is a wizard that will guide you through the process. There is a ton of
information in help and the Northwind database has many, many example.

You drag the sub form onto the main form, make it look pretty, then set the
master child properties in the sub form.

Access will (try to) do this for you if the fields are the same name or you
have set up the relationship already.