I have a form which performs SQL queries on a table. When the form opens
it displays a general query with no parameters. However the user is given
the opportunity to select certain records from the table and the ability to
order them the way he wants. The form is for record selection. This form
is activated by clicking on a button on a screen.
I have just noticed that the first time the query is called it performs
properly however after exiting the query form I try to execute it again the
form opens and displays the initial query but the form is locked. You
cannot select anything nor can you exit.
I have been playing with it. If I issue a 'Set Step On' and then a 'Resume'
the lockup doesn't occur. I can access the form as many time as I want
without lockup. I don't know what is causing the locking and really I don't
care as the form works perfectly. I just want to get around this locking
issue. If a "Set Step On" allows it to function properly the 2nd time thru
then there must be some command I can issue which would give the same result
without causing the user a problem.
Any suggestions would be appreciated.
Eleanor