Maintaining a subform based on a search Query

[mir_99]

i am having problem with a subform that is based on a select query , but the select query is getting the criteria from a textbox located on the main form.
i want the subform to be displayed after a value is entered in the textbox control and a button is pressed.
thanks in advance for help!
with regards
imran a mir

 

[Kensan]

Hi Imram

This might work. In the AfterUpdate event of your textbox requery your subform. You can do it like this

[MainForm]![SubForm].Requery

This forces the the underlying query to be re-run.

Hope this helps

kensan

 

[mir_99]

Thanks Kensan
it did work well!