Hello,
I don't have time now to provide a specific example but I am trying to execute a procedure which is called in a form. The form does the following steps:
1. It calls a list box which opens in another form.
2. The user is required to select a row from this list box which then enters a new record in a table.
3. The calling form then runs a procedure in another module in the same form that does some further processing and saves changes to any records in the calling form.
The problem is that step 3 is never executed. The code runs too fast. In step 2, the list box is only displayed after all the code in the calling procedure is already executed.
I would appreciate if someone could suggest an approach to solve this. I may well have time tomorrow to provide a sample db if needed.
Many thanks.