A trick I use a lot is to create an extra field called recno and fill it

with the record number. Can you do that?

Richard Kaye wrote:

> Possibly you need to wrap the recno() inside str() or transform()?

>

> PLBorkholder wrote:

>

>> Does anyone know how to incorporate the recno() into a list box from

>> the alias that it is pulling from?

>> I need to have the RowsourceType = 2 Alias

>>

>> I have in the Rowsource:

>> certhdr.vcfurno1,loadno1,customer,partno,ponum,htdate,swonum,tokenno

>>

>> I tried adding the Recno() at the end but it errors out:

>> certhdr.vcfurno1,loadno1,customer,partno,ponum,htdate,swonum,tokenno,recno('certhdr')

>>

>>

>> I keep getting the error "Not a character expression"

>>

>> PB

>>

>>

[excessive quoting removed by server]