Create report for one customer/client

[bsltang]

Hi,

I'm merely a novice at Access so please bear with me.

I made a button on the client's form which I want to open a report for that client.

The problem is that the report displays records from all clients.

What i want is to pass the clientID of the form being displayed into the SQL used to fetch the records for the report. Here i'm stuck because I don't know how to put that clientID currently being viewed into the SQL.

Could some one point me in the right direction.

Thanks.

 

[Galaxiom]

Limit the records in your report to only the one person. There are a few ways to do this.
Change the Record Source to a query.
Use VBA DoCmdOpenReport and set the filter or Where clause.
http://msdn.microsoft.com/en-us/library/bb238032.aspx

 

[bsltang]

Right.

So how to I extract the clientID of the current form being viewed so that I can put it into the Where clause.

bsltang.

 

[statsman]

Set the control source of the report to a query.

When you create the query, set the Client Parameter to the name thats on the form.

Example:
[Forms]![FormName]![ClientTextBox]

 

[bsltang]

Thanks GalaxiomAtHome and statsman.