Search results

Thanks both, Cycle property didn't work as it only controls the 'tab' event and not the 'enter' keypress so didn't change the issue. I ended up writing a query that identified the index of the last Bank transaction posted and then a query that picked up the full detail of the transaction based...

Thanks june7 but not entirely helpful - if Quickbooks worked for him I’d have implemented that instead... unfortunately it doesn’t hence the bespoking nature. Error checking is not on the bank record but on whether the data is all correct for the GL transactions to be processed and works fine...

Thanks for the response. So the problem is that a user might update the record leaving it via any control rather than just the control that contains the trigger for opening the additional form. I did think I probably wasn’t being clear enough in the initial post but wanted to keep it short...

Hi all, I have a form with a subform in it. In the afterupdate event of the subform I have a macro set to run which checks whether the value in a certain control is a particular number. If it is then I want to open up another form to enter some additional detail about that record. The problem...