Open report from continues form

[rscott1989]

Hello all,



I would appreciate any help with this!

I am trying to generate a report based on certain criteria. I have a form (SearchForm) that when a user types in certain criteria it populates a form that displays general information of the search criteria. From there the user can click on a "show Details" button that opens a sub-form to expand the results. This sub-form is a continues form. What I want to happen is when a user selects a certain record based on the "RecieptNumber", a form will open up with the receipt number and all the corresponding info to go with it . I have it now to where it will populate based on the "BorrowerID". However this shows several records when all i want it to do is show the single selected record. I know this is probably done using a query. However, if i set the criteria for my form to be [Forms]![FormName]![CommandName] then i am prompted to enter the RecieptNumber before the form populates. Any help on this is greatly appreciated!

[pbaldy]

Can't look at the attachment right now. Does this work?

http://www.baldyweb.com/wherecondition.htm