Please find attahced my database sample file.
In the instruction form (based on the Instruction query), I would like for the holder combobox to show only holders for the specific account. I have used an event procedure after update on the account combobox. The problem is that sometimes it works sometime it doesn't.
The instuction table table required AccountHolderID to be populated. I would like to polulate this field based on the selection of both account and holder comboboxes. I'm not sure how to do this. Use a query? a Macro?
Your help would be greatly appreciated.