On load form adding new data to accdb database

See more:

C#

Hello

I have windows form application databinded to accdb database in access 2007. now , I have a form where I input data for maintenance of some inventory. Thing is I want to have unique numbers for each of this input for example: 2011_178
where 2011 represents the current year and 178 is unique number for each input

but I want that on load form to opens automaticaly the next number in textbox so that later on I can look for by that number the specific input
so if yesterday I had couple of inputs
and ended
with 2011_178, then on next load it must show 2011_179 and of course I must have a save button because if I don't save it then 2011_179 wont be saved, and next time I load form it again opens that number.

I have multiple users of this application so the need of automatically producing this number is something I require.

Can anybody help me with some advice