Reloading a form from a query with new conditions

[ianking]

I have a form which displays data from a query - the query uses a parameter value to select a record to display

Is it possible to put a button on this form which will re-load it asking for a new value for the parameter?

thanks for any help,

regards,

Ian

 

[pbaldy]

Try

Me.Requery

 

[David Eagar]

You could create a new form with the parameter as a combobox with an OnChange event procedure (refresh)

Make your current form a subform of this new form and when Parameter is changed, the query of the subform will be refreshed

 

[ianking]

me.requery

Me.requery worked a treat.

Thanks again,

regards,

Ian