Autonumber problem

[laquer09]

I have a database in Access 2000 which was using autonumber to autofill the key, "Item Number" on a form that allows users to input new "Items." I needed to batch input some items so I did it in excel and imported the entire table. Autonumber has now been turned to number and I can't change it back. I was wondering how I could programatically autofill the "Item Number" on the form to be 1 + the Item Number of the last record. Any suggestions?

 

[TonyJollans]

Hi laquer09,

Several ways, but what you need to do is find the maximum value and add 1, so in some event (perhaps on curent) you need code like ..

if isnull(me.Item_Number) Then
    me.item_number = dmax("item number","items") + 1
end if

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.