Equating a table field to a yes/no answer on a form

[julie]

I am trying to populate a field on a form (ie "Invoiced: ")
with a "yes"/"no" answer based on whether a item has been
sent. The determining factor is a invoiceID from a
invoicing table. So if the invoiceID isNull the field
says "No".
Any help would be appreciated.

 

[Chris]

See if this helps:

[field name].Value = Not IsNull([Invoiced].Value)

Called on AfterUpdate of the invoice Field

Cheers

Chris