i want to see the actual serialno instead of Autonumber

[hotmalepiyush]

well i have a form.. where one of teh fields(serial) has a control source of type Autonumber. this form also has a macro which takes it to a new record on opening.. the problem is it shows (AutoNumber) in the serial instead of the actual serial no. which will be assigned to this record.. it will be helpful if some one can suggest how to get the serial no. assigned to that record..

thanx
piyush

 

[Banana]

I'm just a bit concerned here- Are you using this "serial" field as a sequential numbering? If so, then AutoNumber isn't what you want.

Autonumber only guarantees a unique number, not sequential number. Normally, you wouldn't need or want to expose this to your users- your users should be more interested in the actual data than the pointers to the data.

But if you really have a good reason, you could just dirty the record immediately when you have a new record to get the actual integer instead of (Autonumber).

 

[hotmalepiyush]

I'm just a bit concerned here- Are you using this "serial" field as a sequential numbering? If so, then AutoNumber isn't what you want.

Autonumber only guarantees a unique number, not sequential number. Normally, you wouldn't need or want to expose this to your users- your users should be more interested in the actual data than the pointers to the data.

But if you really have a good reason, you could just dirty the record immediately when you have a new record to get the actual integer instead of (Autonumber).

hii banana,
how do dirty the record on opening??
yes i did want what u are suggesting. there is a thread which tells u how to do it. and provides codes too.. i tried it.. asked for some clarification etc etc.. but was not able to get the desired result... so i gave up on that.. thanx.

 

[hotmalepiyush]

actually its not much of a problem.. i asked only for future use.. as of now even if it doesnt shows the record no. its ok.. thanx for ur guidance,