Choosing a Specific Record To Print a Report

[LilBomShl]

I have a table with many records. The primary key or record Id is quite long
and complicated to type. Is there an easy way for the user to be able to pick
the record they want to print for a report without having to type in the
complex key field to ask for the record they want??? The field does have an
imput mask.
Anyway to be able to pick from a list of existing records??

 

[Damian S]

Hi LilBomShl,

Place the command button to print the record on the form that you are
displaying the data on, and then have the query powering the report pick up
the ID field like this:

select * from TABLENAME where IDFIELD = forms!FORMNAME.IDFIELDNAME

Hope this helps.

Damian.

 

[Ofer Cohen]

You can create a form with two objects on it
1. ComboBox where you can display all the Keys from the table, so the user
wont have to type the key, or type few chr and the combo will AutoComplete
the value for the user to choose from, then you can use the link I gave you
in the prev post.

You can use the combo name instead of the records as the link describe

2. Button to open the Report

http://www.databasedev.co.uk/report_from_form_record.html

 

[LilBomShl]

Thank you!! I will try this.

LiL

You can create a form with two objects on it
1. ComboBox where you can display all the Keys from the table, so the user
wont have to type the key, or type few chr and the combo will AutoComplete
the value for the user to choose from, then you can use the link I gave you
in the prev post.

You can use the combo name instead of the records as the link describe

2. Button to open the Report

http://www.databasedev.co.uk/report_from_form_record.html