Set paramter for a query as a Control-Value of a form

[fluppe]

Hello,



i have a question concerning setting of parameters in a query:

I have a query with a parameter and a form with a control ... however, i want the value of the control to be used as parameter in the query.

For example a checkbox "chkb". Now i specify a query as RecordSource (or ...set ... i'm not sure) for a subform and i want it to change the parameter-value with the value of "chkb".

Is it just necessary to assign the name of the parameter correct (in the query-definition, put smth like [Me].[chkb].[Value]), or do i have to set the parameter in VBA ?
And anyway, is it clear what i mean ?

Best regards,

...

[ranman256]

No the ME is useless and really shouldnt be used. It ONLY work inside the form its in.
For queries you must use the ENTIRE path... forms!frmMyForm!chkb
(no need for .value, its the default)

Try to name controls so they are readily understandable, like chkInsured, or cboState. (i know yours is only an example)
That way you know when you examine the query.

Subform is a longer path: forms!frmMyForm!subform!forms!chkb
ALWAYS USE THE BUILDER TO REFERENCE CONTROLS. (the magic wand with elipsis) IT WILL GET IT ALL CORRECT.

[fluppe]

Hi,

thanks for your answer. The BUILDER works great so far, but i think my setting makes it a little complicated.

I have a Form with an underlying table ... for each record in the table (for example record_1) there is a button and when i click it, the next Form opens. The next form is designed to edit entries related to the record in the first form, HERE: record_1.

First of all, when i click the button, the next form is opened, then i set an appropriate value into a control on the opened Form, that references the related entries ... some ID or what of record_1
That works as well ...
But the query is not updated according to that value. And a requery does not seem to solve that ...

So i think it should be something about the sequence in which i do the things ... but i can't get, what it is exactly ...

[fluppe]

... i think i have got it now ... seems alright if i set things up and requery all in the button_click-fcn, and not in the Open_fcn ...
Thanks a lot for your answer and comments and best regards,

...