Don't know very much about forms so sorry if this is a roundabout way of describing my isssue.
I have a table of sales orders that includes a Yes/No field added on called 'SelectedPrint'. I've added this field onto a continuous form as a checkbox so and when the user checks an order, they can print it by clicking a button which runs a vba coded event to run a report for all orders in he order table where 'SelectedPrint' is true.
strSQL = "SELECT Contracts.InvoiceNum FROM Contracts WHERE (((Contracts.SelectedPrint)=True));"
This works for the most part, however the very last order I tick as Print Selected never prints.
I've found that if I click the checkbox, then click the background of the form so the checkbox is selected but not active (i.e the little pencil and dashed border around the object disappears) then it will actually print the order.
Is there anything I need to change in my code or object properties to get around this?