Freedom Computers

ACCESS

Update a specific record.

reply=inputbox("What is the Invoice number")
Recordset.movefirst
do until recordset.eof
if recordset.invoicenumber=reply then
recordset.edit
recordset.invoiceno=reply
recordset.update
exit do
endif
recordset.movenext
loop