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?
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?
I figured it out, use DLookup
I would use VBA / recordset rather than Dlookup. DLookup is very slow; easier with record sets.
Question is why use an unbound form??