printing selected record

[Bill Moore]

I'd like to put a command button on a form that would run a designated report but have the option of only printing selected records. I know I could just use the File/print option using selected records but that only prints the record fields displayed in the form. I want to run a special report that formats and prints more of the records fields. The problem is how have that report print the "currently selected" record or records.

Thx.

 

[llkhoutx]

The Record source of your report should be filtered by the unique ID field of your form record.

 

[ansentry]

Have a look at this sample of mine.


Click Here

Last post in thread.

 

[Bill Moore]

Close - Maybe??

John,

I took a look at your database and have a good idea of how it works. In my app, I took the code for printing the record, substituted my key "groupname" for your "customerID" and placed it in the "on click" event for my cmdPrintReport command button.

When I run my form, and move the record selector to the record I want to print, it prints but with no data. Can't seem to associate the "current record" with what is to be printed.

I didn't place any code in the "on current" event of the form since I really didn't think it applied to my form. (probably wrong!)

Any more ideas?

Thx.

 

[ansentry]

Bill,

Looks to me like groupname is not a number.

Replace this:

StrCriterion = "[groupname]=" & Me![groupname]

With this:

StrCriterion = "[groupname]=" & "'" & Me![groupname] & "'"