Basing a CR Reprot on a selected value from drop menu in MS Access

[teachmecr]

Hi I'm using MS Access as a front end along with CR report ver 10 for reports and SQL server as a back end. All my reports have a column called Account. In Ms Access i have a drop down menu that has all the accounts (coming from a table). What i want is that when a certain account id is selected i want only those accounts and their respective information to be displayed on the report as opposed to all the accounts and their info. can plz someone help me with that. Do i need to code in VB or wat do i need to do. Im fairly new to all this. Thanks. Any kind of help would be appreciated.

 

[synapsevampire]

To invoke a report from Access check out:

http://technicalsupport.businessobj...vbaexeasp&sliceId=&dialogID=7228857&stateId=1

0 7230184

-k

 

[sreeramnavale]

K, I am just curious, I would like to know how you got that URL? I am sure you do not just remember the URL address and give the information when someone faces problem like this. What is the technique you use?

Thanks.