requry a subform (1 Viewer)

[Geordie2008]

Hiya,

I have a form where a user updates the textbox "Criteria"

Once this is updated I want the results of the query to return in a subform.

I have designed the subform and created the query... How (and where do I put the code) to make it update?

Do I need a button? Also can I get a scroll bar in the subform incase lots of results are returned and the user needs to scroll down?

Tnx,
M

 

[Uncle Gizmo]

Is the textbox "Criteria" On the main form, and the subform you mention on the same form?

 

[Geordie2008]

yep, sorry, managed to work this out seconds ago....

I added:Me.[mandy subform].Form.Requery

to the afterupdate of the text box.

Cheers,
M