You have my e-mail, I'll be here untill at least midnight...I will only write in English as all the persons envolved understand it. If any Portuguese does´t understand just write "Traduz" - Se algum Português precisar de tradução por favor apenas pedir que traduzo.
Paulo i will have a long way to became good. There is a sub on Erel routine very usefull:
'This sub will be called before setting any value in table1.
'The value will only be set if Validate returns true.
Sub Validate(column, value)
If column = "Amount" AND Not(IsNumber(value)) Then
Msgbox("Value must be a number!")
By this way i will always known where to update. The VACUUM part (is the first time i ear about it) is not my priority righ now, because i will not delete anything, just insert stock counting. I will look for it later. Right now i must understand how everything works. Next fase i must populate a combobox and learn how to make a SQL command based on the choice from the combo. I will get back to you soon i guess.
Thanks to you all, your help is fantastic. Regards.
cmd.CommandText="Select 'ubic' From 'inventario' Group By 'ubic' Order By 'ubic' Asc" [COLOR="Blue"]Reader.Value=Cmd.ExecuteReader[/COLOR][COLOR="SeaGreen"] 'You forgot this part[/COLOR] Do While reader.ReadNextRow=True ComboBox1.add(reader.GetValue(0)) Loop
UPDATE table SET col1='value1', col2=... WHERE primaryfield = 'rowid'