auto fill one field

[Guest_imported]

Hi again,

I got a database, which has one field which shows the number with "C", like "C08903". It is input manually. But now this field will be changed to be filled automaticly equal to AutoNumber field (another field) when the new record is input. any suggestion? thanks a lot.

 

[jimmythegeek]

Here is a tip for prefixing auto number fields. If you want your auto number field to always start with a "C", then leave the field as an autonumber, and put the following in the Format property of the field in the table:

>"C"

This will work for any field. So if you create a text primary key that will allow 01522, now just put >"C" in the format property, and the users can just enter 01522 when they are data entering, but it will show up as C01522 on any lists, combos, reports, etc.

Don't know if this is what you are looking for or not. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?