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

  • Thread starter Thread starter julie
  • Start date Start date
J

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.
 
See if this helps:

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

Called on AfterUpdate of the invoice Field

Cheers

Chris
 
Back
Top