Custom dialog for parameter query

[uplink600]

I have created a custom pop up form which has a combo box on it linked to a small table containing names of staff. I want to use this form and combo box to select the sales person name on a parameter query. This is just so the user doesn't have to type in the name as this causes errors with in-correct spelling.

Please advise how I can link this form to the query.

Thanks

VC

 

[Mile-O]

as criteria:


[Forms]![MyForm]![MyControl]

 

[maxmangion]

in the criteria section of your query place the following in the field in question.

[Forms]![Formname]![Controlname]

replace formname with the name of your form and controlname with the name of your combo!

 

[uplink600]

Thanks

I tried this but I just get the following displayed in a normal parameter dialog box, no sign of the custom form I created.

[Forms]![SelectSP]![cmbNames]

This is obviously what I entered as the criteria in query design. The form name and control name are correct.

Is there something wrong with the way I created the form or the way the query is designed?

 

[maxmangion]

you need to have the form opened with your value inputted in the field

 

[uplink600]

Sorry Max

I'm not sure what you mean by this.

VC

 

[maxmangion]

do not run your query from the query window. Open your form enter the value in your field and then create a command button and run the query from the form itself.

 

[uplink600]

Thanks

I follow you now, appreciate your help.

VC