Parameter query problem

  • Thread starter Thread starter krcmd1
  • Start date Start date
K

krcmd1

I have a subform in continuous form view, and I'm trying to have a combo list
populated by a query with a criteria specification referencing another
control in the same record on the subform.

There's something wrong with the way I'm specifying the parameter in the
query. The combo list is correctly populated if I specify a value in the
criteria field of the query, but not if I put a reference to the subform
control. Then either the combo box isn't populated, or a parameter is
requested in a window.

The criteria field of the query is "[Forms]![TreatmentPlan]![Plan
Subform].[Form]![ProblemOption]" (without quotation marks)

thank you.
 
Hi,

A couple of things:

Is the control you are trying to reference a field in a table? If so, you
could add it to the query.

Does the control you are trying to reference have any hidden columns? If so
this needs to be addressed.

What does the parameter request window actually ask for? This may be a clue.

Regards

--
<a
href="http://www.software-matters.co.uk/bespoke-database-design.html">Bespoke
Access Database Development</a>
<p>Software Matters</br>
Straightforward solutions that work</p>
 
Back
Top