hi
i m developing a database in access.there is one table with 5 coloumns and one form to enter the data in the table.the coulumns of the table are serial #,product name,platform,version,application name.
now in the form there are 5 fields for each of these coloumns to be filled in by the user while entering data,except for the application name which is a combo box.there are 8 categories for the application name.now,what i wnt is that when i select a particular application name from the combo box,the last+1 serial # of that application name should be displayed in the next field labelled as Serial #.this last+1 serial should come from the serial # coloumn of the table

so does anyone know how can i acheive it.also plz keep in mind that i dont know much about vba or vb,so plz help me.
i will be thankful
bye

waqas ali saif

Do an "After Update" sub that based on the selection of the combo box, goes out and grabs that last seriel number from the recordset and adds 1 to it, and then update the serial # field.

Like this....

Dim rec as recordset
dim intSer as integer

currentdb().rec("yourtable")

rec.movelast
intSer = rec.Fields("Serial #")

me.txtbox = intSer + 1 'this is the box you want to update


I hope this helps

John