The only resonable solution to this I see is if you control the ID yourself. Either use a MAX value or a second table that stores the next ID value.

Compacting the database will solve your problem First, eliminate all records in your table. Then, close the database but leave Access running. The menu bar reduces to three options. Go to Tools > Options > Compact Databases. I am not sure how you would do this at runtime !! :cool:

Another way to do it is after deleting the rows compact the database. Best regards, Mark www.mjsoft.co.uk

SELECT MAX(order_id) FROM buffet_list and then you do the update, OR UPDATE buffet_list SET buffet = 2500 WHERE order_id IN( SELECT MAX(order_id) FROM buffet_list ) or some other flavour, but you get the idea. Andres Manggini. Buenos Aires - Argentina.

I don't understand your question. What kind of input form? Are you trying to insert data from a form into a database? You'll need to provide a clearer defintion of your problem if you want to get any useful help. Michael :-)