Report to only show current record

[JSD1976]

Hello

I have a Data report made from the designer. I'm using a Data Environment connection, linked to an Access db. On click of a button on vb form, I'm showing this report, but it displays all records. I went to the 'Advanced' tab on the Command properties and unchecked the box 'All Records' and specified a max of 1 record, nut still the report shows all records. I was wondering if there is a way to show the report for only the current record in the vb form?

Any help would be greatly appreciated.

Jeremy

 

[johnwm]

You probably need to show us the SQL statement you're using in your command object

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts