form prompts me twice for parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form based on a query that has a paramter, the form has a filter
applied at run time which is applied by an load event. Why is my form
prompting me twice for the query parameter ?
 
hi,
not sure but it does that to me sometimes.
delete the parameter from the query and reenter it. that
will stop it.
 
am trying to find a similar problem as mine and found this discussion.

My report opens with filter criteria from my subform as
Me.Parent!Subform1.Form.Filter and prompting me twice for the query
parameter. My query does not have any parameter. Have you got answer on this?

thanks.
 
Sounds as if the subform's source object (you say this is a report, so why
does it have a subform?) is using a field name that is not contained in the
subform's source object's recordsource query.
 
Back
Top