recordsets behind a report

[suepowell]

Hi,

I have a report that will print out a list of serials numbers against a job number.

Because fo compatability with existing reports, and space considerations I would like to format the serial number control as serial1, serial2, serial3, rather than have 1 serial number on each line of the detail section.

I realise that I must use code format the control from the data I have. When I try to open the table containing the serial numbers as a recordset, using the job number as a filter I get a message saying "Microsoft accesss can't find the field 'jobno' refered to in your expression"

I know the field name is correct because I typed in me. and selected the field name from the list that appeared.

I have tried putting the code on the open event, and activate event of the report, and on the format event of the detail section, (Despiration is setting oin here!)

I wonder if my problem is due to the field I am filtering on not beining available when the form first opens?

Can anyone help with this
Thanks

Sue

 

[suepowell]

Thanks for this Pat, I've tried it and it works, with just a bit of tweeking to make it look the way I want.

I was trying to treat the report like a form, and create my own values for the controls, but I now realise this is not possible.

Thanks again

Sue Powell.