Adding Invoice number by unbound form to update entries in table

[ch4meleon]

Im sure there must be a way to do this but cant think what it is.

I need to be able to get the user to enter a invoice number, I then want the number to be stored against all records that have a yes in the "sold" field and nothing (blank) in the "invoice date" field.

Any help hugely appriciated !

 

[PHV]

Use a query like this (SQL code):

UPDATE yourTable
SET [invoice number]=[Forms]![your form]![invoice number control]
WHERE sold=True AND [invoice date] Is Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ch4meleon]

Thats great PHV thank you !!