D
Darren
Guest
I have a form which is used for user specified query generation.
The users fill in some limited text boxes and from this a query is generated and (supposedly) displayed in a subform.
Ive used this routine with a list box and it works fine, I have a recordcount to ensure the query is being generated and this works fine.
Even when I actually go into the subforms form itself this has worked fine. HOWEVER, the subform display does not seem to propagate the correct results, it seems to use the results of the last time the actual subforms form was opened.
This suggests to me that the requery on the subform is not working - I believe this may be due to not having links but I cant see how I can link between a query that is only generated following user input and the subform. (Clearly I cannot have a bound record source for the form itself, since the query does not exist when the form initialises ).
Ultimately how do I get the subform to requery ?? ( without putting the subform on another pop up form - I know this works!)
Yours going round in circles..
[This message has been edited by Darren (edited 01-20-2000).]
The users fill in some limited text boxes and from this a query is generated and (supposedly) displayed in a subform.
Ive used this routine with a list box and it works fine, I have a recordcount to ensure the query is being generated and this works fine.
Even when I actually go into the subforms form itself this has worked fine. HOWEVER, the subform display does not seem to propagate the correct results, it seems to use the results of the last time the actual subforms form was opened.
This suggests to me that the requery on the subform is not working - I believe this may be due to not having links but I cant see how I can link between a query that is only generated following user input and the subform. (Clearly I cannot have a bound record source for the form itself, since the query does not exist when the form initialises ).
Ultimately how do I get the subform to requery ?? ( without putting the subform on another pop up form - I know this works!)
Yours going round in circles..
[This message has been edited by Darren (edited 01-20-2000).]