Query in Form

  • Thread starter Thread starter JLDLS
  • Start date Start date
J

JLDLS

I have created a project tracking database in Access 2007. I have seperate
tables/forms for clients and projects. The tables are linked by client name
(originates in the client table and is selected in the project table). On my
clients form I have added a tab that I would like to use to display all the
projects for that client. I am assuming that I will need to use a query in
the form to accomplish this. How do I get the query to instead of asking for
a name, to select the name of the curent open client in the form? Thanks.
 
I have created a project tracking database in Access 2007.  I have seperate
tables/forms for clients and projects.  The tables are linked by clientname
(originates in the client table and is selected in the project table).  On my
clients form I have added a tab that I would like to use to display all the
projects for that client.  I am assuming that I will need to use a query in
the form to accomplish this.  How do I get the query to instead of asking for
a name, to select the name of the curent open client in the form?  Thanks.
Click to expand...

Use a subform. On the properties of the subform there is a set of
properties: Master Link Field and Child Link Field. Set them to the
ClientID in the appropriate table and it will link them so whichever
client you have selected, the matching records will show in the
subform.

Keven Denen
 
Back
Top