Criteria and Results on same form (1 Viewer)

[TStock]

I am trying to enter criteria for a query and get the results on the same form. I have added a subform that uses the query as a record source. That works but the only way I can get it update for new criteria is by going to design view then back to normal view.

What the heck am I donig wrong??

Thanks in advance for any help

T

 

[jimbrooking]

For the AfterUpdate event for the control that contains the query criterion, put in a line like

Me.Requery

Were it my form I'd probably put the query criterion on te main form (an unbounded control) and have the query results on a subform. In this case the requery would be more like

Me.frmSubForm.Requery

(still in the AfterUpdate event for the query criterion).

HTH...

Jim

 

[bril_mo]

I have a similar problem with my form. Could you tell me what that criterion looks like, where i put it and how i get the subform to display the query results? Thnx