Requery a form that has a filter attached

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

Hi

I am trying to requery a form that is based on a query and a filter.
If I try to requery I get a window asking me to enter Sale Date. How
can I pass the sale date parameter along with the requery command. I
can't use refresh as I want to show changes to the form.

-------- Code used ----------
Me.Requery

----- Properties -----
RecordSource= Q-Tsale (Select Name,time,[sale date] from TSales)
Filter = [sale Date]=[Forms]![FrmSale]![Sale Date]
--------------------------------------------------

Please help.

Thanks
-Max
 
The form [FrmSale] has to be open when you do a requery to be able to get the
date from [Sale Date].

What happens when you try

Filter = [sale Date]= #8/29/2004#


Change 8/29/2004 to a date you know will return records.
 
Back
Top