Search results

Thanks Galaxiom for your input but... Form_Invoices.InvoiceSearch_AfterUpdate = Works OK Form!Invoices.InvoiceSearch_AfterUpdate = Does not work! - I get the return "Runtime error 2465 Microsoft Access can't find the field invoices referred to in your expression"

Many thanks for looking at my query your suggestions put me on the right track and the call I have found to use is Form_Invoices.InvoiceSearch_AfterUpdate

Thank you for responding. In order to keep it simple I created two forms. Form1 has a text box with a private sub changed to a public sub which for testing purposes has a message box response. Form2 just has a command button with the code to call the afterupdate event of the text box on...

The following code used to work fine in Access 2003 but refuses to work in Access 2016... Googled many results and tried various suggestions to get the call working but nothing works. Any idea as to the correct syntax I should be using please? Call Forms.Invoices.InvoiceSearch_AfterUpdate

Thanks guys... I should have remembered that

A have noticed a lot of queries regarding changing the back colour of a text box in continuous forms within these forums and others. Years ago I created our database which has just this feature incorporated.. it has no events or code associated with Table1 or Form1, yet the CID field on Form1...