Clicking Reports

[romh]

I need to display records and have the ability to click on a particular record. I usually use a form's continuos view instead of a report. But, I need a more complex grouping and sorting of records, which only a report can give me. Additionally, I need to have the ability for the user to click on the record, and open another form. Essentially, it is a search screen that diplays Invoices, and the user would click on an Invoice to go to the Invoice form.
The problem is that once a Form is set for Continuous view, you cannot add a subform to it. So, a report is the only way to diplay the data in the manner that I want.

Does anybody have any other suggestions? Thankyou

I am using Access 2000.

 

[CosmoKramer]

I would go with a list box or combo box control. You can set your query as the record source for the control, then assign code in either the On Click or On Dbl Click events to open the form for the record you choose.

 

[romh]

Thanks, but a list box cannot possibly duplicate the results of a continous form or a report when subforms and subreports are needed. Right?

Thankyou

 

[CosmoKramer]

I don't think I would use a continuous form in this case.

I do this sort of thing all the time. Say a users wants to see all appointments for a patient. They can enter criteria like first name, last name, etc. (allowing for wildcarding). A command button will populate a combo box with the results of a query that has been passed the users' criteria. This combo box can also include other fields found in the patient table to help further identify the patient (date of birth, sex, etc.) that was not originally entered.

In the On Click or On Dbl Click event of this combo box you can enter code that will open a form that will utilize linked data from the record that the user clicked on (i.e. a patient ID) to return their appointments.