S
Simon
i have a button on my order form that i click that will create an
invoice
i also have a tick box on my form when the order is Invoiced
the code below works fine for when i create an invoice it loads up the
form and tick the box
I woild like some code that will bring up a message ( Invoiced already
create) if the tick box is already tick. if its not ticked then it can
run my code below
Me.Dirty = False
If MsgBox("Do You Want to Create an Invoice?", vbQuestion + vbYesNo,
"New Order") = vbYes Then
DoCmd.OpenForm "frminvoiceNumber", , , , acFormAdd
Forms!frmInvoiceNumber![OrderNumber] = Me.OrderNumber
Invoiced = True
invoice
i also have a tick box on my form when the order is Invoiced
the code below works fine for when i create an invoice it loads up the
form and tick the box
I woild like some code that will bring up a message ( Invoiced already
create) if the tick box is already tick. if its not ticked then it can
run my code below
Me.Dirty = False
If MsgBox("Do You Want to Create an Invoice?", vbQuestion + vbYesNo,
"New Order") = vbYes Then
DoCmd.OpenForm "frminvoiceNumber", , , , acFormAdd
Forms!frmInvoiceNumber![OrderNumber] = Me.OrderNumber
Invoiced = True