record select for report question

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I'm looking for a record in the datasheet and want to print a report for
that record - what is the simplest way to go about that?
 
The simplest way is to use a Form, not a datasheet, and put a CommandButton
on the Form... use the unique ID of the currently selected record to create
the WHERE clause without the WHERE that is needed for the WhereCondition
argument of DoCmd.OpenReport... something like

Dim strWhere as String
strWhere = "[SerialNumber] = " & Me!txtSerialNumber
DoCmd.OpenReport "rptSomeRep",,,strWhere

Larry Linson
Microsoft Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print every other record in a form 13
Report that selects a single record 3
counting records 0
Report sorting 1
Saving page number from report 5
A03 - count in report footer gives me #Error? 0
Setting Report's RecordSource 8
Selecting records to print at end of report 1

Back
Top