retrieving a record from a table

[crowegreg]

I have a table which contains an invoice number. Withn an unbound form, I'm needing to retrieve the invoice number from the table, add a quantity of 1, then save the new number to the table.

How's the easiest way to do this?

[crowegreg]

I figured it out, use DLookup

[ssanfu]

I would use VBA / recordset rather than Dlookup. DLookup is very slow; easier with record sets.

Question is why use an unbound form??