Access forms wih parameter queries

[Guest]

I have a parameter query that asks three questions. The query results are
limited by these criteria. How can I have these questions asked in a form
in-line, rather than as a popup dialog for each one? I have built the form
already from the query, and am accessing the "Control Source... Expression
Builder" dialog to hopefully allow a data connection between these three form
text boxes and the criteria used as a parameter. I don't know how to drill
down in the expression builder dialog to make this happen. Thank you in
advance.

 

[Guest]

hi
see my reply to Drew in access general questions
subject: Passing form value to query
Time posted: mar 3 2005 6:00AM

 

[Guest]

Thank you. I am almost there with this. The query is returning no results. I
presume this is because I don't have the reference quite right.

In the criteria field (for each of the three parameters) I have an
expression that looks like this:

[forms]![FORM TryForm]![ProjectComboBox]

My guess is I'm not building on your example completely enough. In the
above, ProjectComboBox is a real thing specific to my db. Same with the form
which is named FORM TryForm. I wonder about the first reference "forms", is
this a univeral thing likely to be relevant to my db as stated above, or do I
have some sort of custom name I have to look up.

Thanks, I hope this makes sense.

 

[Guest]

Nevermind, I was accidentally looking at the friendly name for the combobox.
Thank you.

Thank you. I am almost there with this. The query is returning no results. I
presume this is because I don't have the reference quite right.

In the criteria field (for each of the three parameters) I have an
expression that looks like this:

[forms]![FORM TryForm]![ProjectComboBox]

My guess is I'm not building on your example completely enough. In the
above, ProjectComboBox is a real thing specific to my db. Same with the form
which is named FORM TryForm. I wonder about the first reference "forms", is
this a univeral thing likely to be relevant to my db as stated above, or do I
have some sort of custom name I have to look up.

Thanks, I hope this makes sense.

hi
see my reply to Drew in access general questions
subject: Passing form value to query
Time posted: mar 3 2005 6:00AM