What I want to do is: 1) Open a form which is based on a parameter query 2) Fill in the parameters 3) Examine the result and either edit some of the records or insert new ones (which may or may not conform to the parameter) 4) Press a button to reload the form with the same parameter to check that what I've done is OK. At the moment the button can reload the form, but I have to retype the parameter, which is error-prone and a bit of a PITA. Please provide an API to let me do this.
With parameters for a query you will restart the query when reloading the form. Better would be to add the parameters in the mainform and work in the subform. So you could reload the subform and you haven't to retype the parameters.
I agree that this is one way to do it - you were kind enough to send me some code when I raised this issue in the forum. But even easier (for the programmer) would be the API function. If no-one else wants it, that's fine. At least one other forum member suggested that I should raise the issue as an RFE. So I did (albeit 7 months later).
OK, so no idea on this one, but we can ask our resident Base code caretaker. @Lionel : what's your opinion ?
Oops, forgot to set this to confirmed as RFE. Done.