search wont work with autonumber

[gilo]

I have set up a new database and am using an Autonumber to generate a unique number for my records. I wanted the numbering to start from 500000. So in my table I put /500000 in format in field properties.

I now want to search for particular records in a form and it does not pick up the autonumber format - even though it shows as eg 500001 in the table and on my form I have to put 1 in my search field for it to display 500001.

What am I doing wrong
please dont shout at me!!

 

[pat_nospam]

Hmm - I think if you take the /500000 out of the format (all that is doing is masking the true autonumber) and then put "500000" into the autonumber data field (in table view) to seed the start point, the autonumber should increase from 500000 on.

Hope this helps,

Pat