yes, u r right. Auto number is getting displayed if i goto any of subforms. But i want to dispaly it on the main form before going to any subform.
i am also using teh access 2003 front end and sql 2005 linked tables.And my autonuber field is primary key on the table.
Can you clarify what do...